Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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🙂
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🙂
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.
how can I identify that? any suggested formula? Thank you!
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.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |