Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm stuck trying to build both a table and a line chart where the data is grouped by day, month, and year and the table needs to show the balance of the last index by groups.
This is the dataset. Each date has multiple index values and I need to select the Balance of the highest index, based on date. This will be used as input in a line chart to plot ending balance of the day.
I've played around with SUMX, TOPN, and MAXX but can't seem to cross reference correctly.
Solved! Go to Solution.
Moments after posting I managed to figure it out...
Moments after posting I managed to figure it out...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |