Forum Discussion
fahmi_laswar
7 years agoFrequent Visitor
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
3 Replies
- AlB
Community Champion
Hi fahmi_laswar
Try this:
Measure = MAX(CalendarTable[Date])
where CalendarTable[Date] is the field you use in the slicer
- fahmi_laswarFrequent Visitorthanks for your replay,but the result show the max date in table not the filterd date in slicer
- AlB
Community Champion
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