Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Thanks for looking at my post. Very new to PBI here.
I am trying to calculate the latest derived_account_health for each quarter (I want to show the latest health by qtr) However, the aggregation only lets me do First and last which is just sorting the health alphabetically. I actually want the latest value associated with the qtr.
The table on the right actually shows when the snapshot was taken and the derived health in a non summarized form. Can someone please point me in a direction or guide me to achieve this?
This thread has a similar question that has been answered: https://community.fabric.microsoft.com/t5/Desktop/How-to-get-value-from-last-date-most-recent-by-cat...
You should be able to adapt a solution to fit your needs.