Filter based on the last date snapshot and get latest activation dates

[AvanthaPeiris]

Hi all
Thanks a lot for the support given, and the community solution, Replicate D-1 to D-3 summary sales table in Power BI table visualizationvisualisation resolves my main issue.

However, there is another twist to the dataset where there is a daily snapshot created and added to the dataset, so the final dataset looks like this.

Activated_Date Product Amount DATA_LOADED_DATE
17/04/2025 00:00 A 74339166.78 17/04/2025 00:00
17/04/2025 00:00 B 5828750 17/04/2025 00:00
17/04/2025 00:00 C 15100000 17/04/2025 00:00
17/04/2025 00:00 E 7970000 17/04/2025 00:00
16/04/2025 00:00 A 50354865 17/04/2025 00:00
16/04/2025 00:00 B 7076018.25 17/04/2025 00:00
16/04/2025 00:00 C 23100000 17/04/2025 00:00
16/04/2025 00:00 E 1500000 17/04/2025 00:00
11/04/2025 00:00 A 74924669 17/04/2025 00:00
11/04/2025 00:00 B 10610334.38 17/04/2025 00:00
11/04/2025 00:00 C 21790000 17/04/2025 00:00
11/04/2025 00:00 E 7385000 17/04/2025 00:00
16/04/2025 00:00 A 50354865 16/04/2025 00:00
16/04/2025 00:00 B 7076018.25 16/04/2025 00:00
16/04/2025 00:00 C 23100000 16/04/2025 00:00
16/04/2025 00:00 E 1500000 16/04/2025 00:00
11/04/2025 00:00 A 74924669 16/04/2025 00:00
11/04/2025 00:00 B 10610334.38 16/04/2025 00:00
11/04/2025 00:00 C 21790000 16/04/2025 00:00
11/04/2025 00:00 E 7385000 16/04/2025 00:00
11/04/2025 00:00 A 74924669 15/04/2025 00:00
11/04/2025 00:00 B 10610334.38 15/04/2025 00:00
11/04/2025 00:00 C 21790000 15/04/2025 00:00
11/04/2025 00:00 E 7385000 15/04/2025 00:00
It contains a sequence of DATA_LOADED_DATES, and for the visualisation, we need to select the maximum one, which needs to be done via a Slicer. I tried it with the solution given in the Replicate D-1 to D-3 summary sales table in Power BI table visualization, but it failed. Kindly assist me with this situation, too.

Thanks again

[Akash_Varuna · Accepted solution]

Hi @AvanthaPeiris You can create a measure like this:

Latest_Loaded_Date = MAX(YourTable[DATA_LOADED_DATE])

Then, use this measure in a slicer and filter your table to show only rows where DATA_LOADED_DATE matches the latest date.