Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |