Dynamic data for max date based on date slicer selection

[Anonymous]

Hi, I am stuck with a challenge, where I need to show the Latest date of each ID(Each ID has multiple entries at different dates and times), but the catch is, there is a date slicer(Between option), so when we change the date in the slicer, Table should show the latest data based on the slicer. For example, the overall date range is from 01st April 2021 to 31st March 2022, so if the latest date for id 707 is 18th March, only this should display, but if the slicer is changed to 15th Apri1 2021 to 01st March 2022, then the latest date between this should display for ID 707 which may be 25th Feb 2022

Accordingly, with ID 707, we have multiple ids and all should display their latest data as per selection

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the following formula:

Measure = 
CALCULATE ( 
    MAX ( 'Table'[Date] ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[ID] = MAX ( 'Table'[ID] ) )
)

         

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yulgu-msft @ssugar @Greg_Deckler @amitchandak @Ashish_Mathur Need help