Forum Discussion
Helper VDateSlicer "Between" + MaxDate
Hello cn4422 ,
You have couple of options available and I have covered in a similar post, here is the link :
You can modify slightly to show max date instead of today, Kindly check and let me know.
I hope this helps.
Did I answer your query ? Mark this as solution if this helps, Kudos are appreciated.
Warm Regards,
Neeraj
Super Usercn4422 Create a measure that calculates the maximum date in your dataset. This measure should always return the latest date available in your data.
Max Date = MAX('YourTableName'[DateColumn])
Use this measure in a new measure that adjusts the end date of your slicer based on the maximum date in your dataset.
Adjusted End Date =
IF(
SELECTEDVALUE('YourTableName'[DateColumn]) = MAX('YourTableName'[DateColumn]),
MAX('YourTableName'[DateColumn]),
SELECTEDVALUE('YourTableName'[DateColumn])
)
Update your visual-level filter to use the "Between" setting with the start date as the minimum date in your dataset and the end date as the "Adjusted End Date" measure.
Helper VHi bhanu_gautam ,
thanks for your reply and sorry for my late reply. 🙂
I've created the two measures as suggested:
1)
2)
Where can I set a specific date with the "Between" setting?