Forum Discussion
Solved
Running Total
Hi My excel table is downloaded from SAP, there is column for Fiscal Year, and another column for Posting Period (which indicate 1, 2 , 3 etc representing the month). May i know how to generate DA...
RLOH See if this helps: Better Running Total - Microsoft Power BI Community. In your case it would be something like:
Better RT = VAR __Year = MAX('Table'[Fiscal Year]) VAR __Month = MAX('Table'[Posting Period]) VAR __YearMonth = __Year * 100 + __Month VAR __Table = FILTER(ALLSELECTED('Table'), [Fiscal Year] * 100 + [Posting Period] <= __YearMonth ) RETURN SUMX(__Table,[Value])File attached. See signature.
Hi,
What should the order be for generating the Running total?
Hello,
The order must be given by the column num.
I would prefer it it be a measure so it can be affected by slicers.
In a dax it wont be affected by slicers