Forum Discussion
grouping by values
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?
1 Reply
vicky_Super User
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-category-using-a/td-p/3054287
You should be able to adapt a solution to fit your needs.