Untitled

 avatar
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...