Compare Dates (DAX)
Column Name = SWITCH (
TRUE() -- check if true
, [Date] > DATE(YEAR(NOW()) - 1, MONTH(NOW()), DAY(NOW())), "< 1 Year" -- condition, result
, [Date] >= DATE(YEAR(NOW()) - 3, MONTH(NOW()), DAY(NOW())) && [Date] <= DATE(YEAR(NOW()) - 1, MONTH(NOW()), DAY(NOW())), "1-3 Years" -- condition, result
, "3+ Years" -- unknown value
)