Forum Discussion
Solved
Rolling Date Range With a Message
Hey Everybody, I am trying to set up a rolling measure that says 'Less Than a Year', 1 to 5 Years', or 'Greater Than 5 Years' for data in the form mm/dd/yyyy. I have set up a calculated column to...
The end goal is to have a column next to 'Emp_HireDate' column that says 'Less Than a Year', 1 to 5 Years', or 'Greater Than 5 Years' for each entry.
i820017 understood but from your post, it looks you have already solved it by adding a column, why you need a measure. Sorry it is not clear
You are right. I do not need to do this as a measure. Here is my DAX expression to create the column.
Emp_Hire_Date_Split2 = IF('ops SurveyDetails'[Emp_HireDate] > TODAY() - 365, "Less Than 1 Year",
IF('ops SurveyDetails'[Emp_HireDate] < TODAY() - 1825, "Greater Than 5 Years",
"1 to 5 Years"))