Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |