Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Can you tell me how to calculate cummulative sum (CumulatieSumOfMeasure1And2) of differance between measure1 and measure2 ? While measure1 and measure2 are calculated from other table's column using calculate method
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Here is the link of row data : https://drive.google.com/file/d/1BGRTRJwvlvlSOp5LGZGS7RifNLNqtfqt/view
I need to have CUMULATIVE sum of BalanceForcast mesure in table ForcastedBalane, not just sum
hi, @giorgi_lommidd
Please re-upload the file, This link requires permissions.
and if this formula could meet your requirement?
Cumulative sum of measures = CALCULATE([Measure1]+[Measure2],FILTER(ALL(TestTable),TestTable[Date]<=MAX(TestTable[Date])))
By the way, the TestTable should create a relationship with ForcastedBalane by date column.
If not your case, please share the expected output based on your sample data.
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |