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 All,
I have been struggling with this for the past couple hours, I thought I had it till I realized I did not. What I am trying to achieve is to grab the value from the last month of every quarter and display only that in a chart, instead right now my SUM(Balance) shows the sum of all months within that Quartr. My data is like below:
QUARTERS | YEAR.MONTH | BALANCE |
2017-Qtr 4 | 2017-December | 7000 |
2018-Qtr 2 | 2018-April | 2000 |
2018-Qtr 3 | 2018-August | 100 |
2018-Qtr 1 | 2018-February | 1000 |
2018-Qtr 1 | 2018-January | 1000 |
2018-Qtr 3 | 2018-July | 100 |
2018-Qtr 2 | 2018-June | 2000 |
2018-Qtr 1 | 2018-March | 9000 |
2018-Qtr 2 | 2018-May | 4100 |
2018-Qtr 3 | 2018-September | 500 |
And I want the end result to be:
QUARTERS | BALANCE |
2017-Qtr 4 | 7000 |
2018-Qtr 1 | 9000 |
2018-Qtr 2 | 4100 |
2018-Qtr 3 | 500 |
I tried using ENDOFQUARTER but that did not return my intended result.
Thank You
Solved! Go to Solution.
I think I figured it out by using CALCULATE(SUM(BALANCE), ENDOFQUARTER(DATE)). let me know if someone else handles it better and in a different manner.
Thanks!
I think I figured it out by using CALCULATE(SUM(BALANCE), ENDOFQUARTER(DATE)). let me know if someone else handles it better and in a different manner.
Thanks!
Hi @nirvana_moksh,
By my research, I'm afraid your formula should be the most simple.
Best Regards,
Cherry
Thank you for confirming!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |