I am struggling to identify a solution to a common problem resolved in the forums. Out of ignorance I have blindly attempted multiple suggestions but I have not been successful.
I have 2 measures.
1. The below measure returns whatever the selected value is from a slicer
Selected Project = SELECTEDVALUE('Programme Financials Unpivot'[Project No.], BLANK())
2. The below measure sums a column by multiple conditions. The measure above is also used as part of a condition.
Total = CALCULATE(
SUM('Programme Financials Unpivot'[Value]),
'Programme Financials Unpivot',
'Programme Financials Unpivot'[Attribute] = MIN(Period_Table[Attribute]) && 'Programme Financials Unpivot'[Period Snapshot] = 12 && 'Programme Financials Unpivot'[Project No.] = [Selected Project]
I now want to create a cumulative/running total of the Total measure.
Could you anyone please advise? The solutions I use often return the same result as the Total measure.
Solved! Go to Solution.
Hi @themistoklis thanks for the suggestion.
I do not want to apply a cumulative/running total measure using the "Programme Financials Unpivot" table as the source. I am actually trying to apply this measure to the Total measure in the table I displayed above.
This table is a custom table. The values returned by the Total measure are derived from "Programme Financials Unpivot" table using a number of conditions.
Do you know if this a way to apply a running total/cumulative to this table?
Can you try the following:
Running Total =
CALCULATE ( [Total] ,
ALL ( 'Programme Financials Unpivot' ),
'Programme Financials Unpivot'[Index] <= EARLIER ( 'Programme Financials Unpivot'[Index] )
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps