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,
Upload the file to Google Drive and share the download link here. Show the expected result very clearly.
hI,
This is the PBIX file that i am trying to work on.
https://drive.google.com/file/d/1ALCir7Vhs1sEqvJ8jTzpr7820mv26D0C/view?usp=sharing
This is the excel spreadsheet that contain the data and the dashboard (the result)
Hi,
See if my solution here helps.
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.