Forum Discussion
Solved
Date Slicer, Set a specific date at opening
Hello all, II not found exactly what I am looking for. I have a slicer by date (Calendar by Tallan) and when I open the report I want that the selected date is the max date, sometime the max date is...
Hi sdionne,
The column should be in the table [Calendrier]. The formula could be as follows. Then it will work with the dates.
Column = VAR maxDate = MAX ( StatProcessus[Hier] ) RETURN IF ( [Date] = maxDate, 1, 0 )
BTW, make sure you didn't share anything sensitive.
Best Regards,
unfortunately, i tried but it is not working, can you show me an example or give me more details please.
Thanks
sdionne
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi sdionne,
The snapshots in my last post are quite clear. Can you share your example again? I can't access the link in your last post.
Best Regards,
- v-jiascu-msft
Hi sdionne,
The column should be in the table [Calendrier]. The formula could be as follows. Then it will work with the dates.
Column = VAR maxDate = MAX ( StatProcessus[Hier] ) RETURN IF ( [Date] = maxDate, 1, 0 )
BTW, make sure you didn't share anything sensitive.
Best Regards,