Forum Discussion
Solved
get last date from filter slicer
how to create measugre to Get the last date in filter slicer
Hi fahmi_laswar
Try this:
Measure = MAX(CalendarTable[Date])
where CalendarTable[Date] is the field you use in the slicer
AlB
Community Champion
Community ChampionHi fahmi_laswar
Try this:
Measure = MAX(CalendarTable[Date])
where CalendarTable[Date] is the field you use in the slicer
thanks for your replay,but the result show the max date in table not the filterd date in slicer
- AlB
Hi fahmi_laswar,
Can you share the pbix and I'll have a look? If you have confidential data, share a file with dummy data that reproduces the issue.
Cheers