Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
This is my measure Cashflow forecast = CALCULATE(SUM(Beginbalans[Periode beginsaldo]) + [Liquide middelen] + SUM('Debiteuren'[Bedrag]) + SUM('Crediteuren'[Bedrag])) I would like to have the cumulative per month.
Solved! Go to Solution.
Ah... there is your problem. What you're trying to do is calculated a running total.
Now in your example, there is a row context. So for every row you're doint the calculation. What you should do, is create the a total till the current rowcontext.
A running total is explained here at the DAX patterns site.
Query should look like this:
MeasureName = CALCULATE ( [YourMeasure]; FILTER ( ALL ( datetable[date] ); datetable[date] <= MAX ( datetable[date] ) ) )
I've also created an example file for you which you can download here.
Hope this works for you.
- Marc
Why are you using Calculate in this case? You aren't applying any filter context.
Regarding your question. Add this measure to a column chart with the months on your x-axis... This should work, in case this results in the same value for every month, check your relationships in your model and your DAX measures. Your referencing other measures like [Liquide midellen] which might impact the filter context of your measure.
- Marc
I thougt Calculate wass neccesary. Now i see it doesn't. But the result of sum is the amount per month and not the cumulative per month. this is my result:
Openingbalans Cashchanges Receivables Payables Cashflow
Jan 362441,14 -94613,17 0 0 267827,97
Feb 0 -271768,02 0 0 -271768,02
What i want to see is 267827,97 - 271768.,02 = -3940,05
Ah... there is your problem. What you're trying to do is calculated a running total.
Now in your example, there is a row context. So for every row you're doint the calculation. What you should do, is create the a total till the current rowcontext.
A running total is explained here at the DAX patterns site.
Query should look like this:
MeasureName = CALCULATE ( [YourMeasure]; FILTER ( ALL ( datetable[date] ); datetable[date] <= MAX ( datetable[date] ) ) )
I've also created an example file for you which you can download here.
Hope this works for you.
- Marc
User | Count |
---|---|
134 | |
72 | |
71 | |
55 | |
54 |
User | Count |
---|---|
201 | |
95 | |
63 | |
62 | |
51 |