How to filter automatically the latest date available in a data?

[jovendeluna21]

Hello,

Anyone who knows to create a calculation on which the latest date and its data only will appear on a page?

Thank you!

https://drive.google.com/file/d/1N7fl0SMrgOKRS8IYJauaqm8X1wJNXKxt/view?usp=sharing

[PC2790 · Accepted solution]

Hi @jovendeluna21 ,

A calculated column to get the latest date will do the trick.

DAX formula:

Latest_date_column = IF(Vaccination[Record Date] = MAX(Vaccination[Record Date]), "Latest Date", FORMAT(Vaccination[Record Date], "MM-DD-YYYY"))

Logic implemented in the file present here

Thanks

Appreciate your Kudos🙂

[jovendeluna21]

Thank you @PC2790 ! Appreciate your help! 🙂

[mhossain]

Hello @jovendeluna21 

Many ways to do that, I think easiest would be in your PowerQuery create a calculated column which identifies latest date and tags it "Latest" maybe.

Then on your page apply "Latest" filter, it should solve the purpose. Please share more details if it is not working.

[jovendeluna21]

how can I identify that? any suggested formula? Thank you!

[mhossain]

@jovendeluna21 

If you want to identify in PowerQuery, this linke might be useful - https://stackoverflow.com/questions/50457881/how-to-find-the-most-current-date-from-a-column-in-powe...

In DAX environment also, you can try MAX().

Hope above makese sense.