Forum Discussion
DateSlicer "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
cn4422 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.
Hi bhanu_gautam ,
thanks for your reply and sorry for my late reply. 🙂
I've created the two measures as suggested:1)
Max Date = MAX('MaxDatum'[LetztesDatum])2)
Adjusted End Date =IF(SELECTEDVALUE('MaxDatum'[LetztesDatum]) = [Max Date],[Max Date],SELECTEDVALUE(MaxDatum[LetztesDatum]))However, I'm not sure how to achieve this: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.Where can I set a specific date with the "Between" setting?
