Untitled
user_3592770
plain_text
2 years ago
976 B
6
Indexable
Time Period = SWITCH( TRUE(), 'earthquakes'[year] >= 1900 && 'earthquakes'[year] < 1910, "1900-1909", 'earthquakes'[year] >= 1910 && 'earthquakes'[year] < 1920, "1910-1919", 'earthquakes'[year] >= 1920 && 'earthquakes'[year] < 1930, "1920-1929", 'earthquakes'[year] >= 1930 && 'earthquakes'[year] < 1940, "1930-1939", 'earthquakes'[year] >= 1940 && 'earthquakes'[year] < 1950, "1940-1949", 'earthquakes'[year] >= 1950 && 'earthquakes'[year] < 1960, "1950-1959", 'earthquakes'[year] >= 1960 && 'earthquakes'[year] < 1970, "1960-1969", 'earthquakes'[year] >= 1970 && 'earthquakes'[year] < 1980, "1970-1979", 'earthquakes'[year] >= 1980 && 'earthquakes'[year] < 1990, "1980-1989", 'earthquakes'[year] >= 1990 && 'earthquakes'[year] < 2000, "1990-1999", 'earthquakes'[year] >= 2000 && 'earthquakes'[year] < 2010, "2000-2009", 'earthquakes'[year] >= 2010 && 'earthquakes'[year] < 2020, "2010-2020", "Other" )
Editor is loading...