Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Solved! Go to Solution.
Hi @smshetty ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a date dimension table
2. Use the Date field of date dimension table as slicer option
3. Create a measure as below to get the status
Measure =
VAR _maxseldate =
MAX ( 'Date'[Date] )
RETURN
IF (
DATEDIFF ( SELECTEDVALUE ( 'Calculation'[Date] ), _maxseldate, DAY ) <= 30,
"30 days",
"30 days beyond"
)
Best Regards
Hi @smshetty ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a date dimension table
2. Use the Date field of date dimension table as slicer option
3. Create a measure as below to get the status
Measure =
VAR _maxseldate =
MAX ( 'Date'[Date] )
RETURN
IF (
DATEDIFF ( SELECTEDVALUE ( 'Calculation'[Date] ), _maxseldate, DAY ) <= 30,
"30 days",
"30 days beyond"
)
Best Regards
I'm trying to do the same thing except i want the user to select from the slicer, 60,90,120 days. The selection will tell them what contracts are coming up for assesment based on the End Date. In excel i just say end Date-60. But i don't know how to create a measure that can be put into a slicer where it can determine what contracts are ready to be reviewed for renewal. If the contractor knows what is coming up for assesment then they can send out their reminders prior to that to get the ball rolling for coordination.
Thank you so much ... Its helpful.
/@smshetty are you adding it as a measure or a column
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.
@smshetty you have to add it as a measure then use MAX of date instead of TODAY()
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.
Max function goes to max available date which can be today too.. I want it to use the end date selected by the use in the date slicer
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |