get last date from filter slicer

[fahmi_laswar]

how to create measugre to Get the last date in filter slicer

[AlB · Accepted solution]

Hi @fahmi_laswar 

Try this:

Measure = MAX(CalendarTable[Date])

where CalendarTable[Date] is the field you use in the slicer

[fahmi_laswar]

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