Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |