Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
i820017
Resolver II
Resolver II

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 

'ops SurveyDetails'[Emp_HireDate].
i820017_0-1622057353039.png

 

Thanks,

Dan

1 ACCEPTED SOLUTION

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.

View solution in original post

5 REPLIES 5
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@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 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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"))
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.