Forum Discussion
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 do so, but I would rather do it as a measure instead. The name of the column is
Thanks,
Dan
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.
5 Replies
i820017 expression you used in the column, change MAX ( table[hire date] ) in your expression and add it as a measure, not sure what your end goal is.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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.
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"))
i820017 makes more sense, that's why I was not sure why you need a measure. glad it was already solved.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
