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.
Ashish_Mathur unfortunately, the link that you are provided is blocked by my company safety network because the site is not secured. Any chance you can upload the file in this PowerBI Community platform ?
File attached. See signature.