Forum Discussion
Running Total
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 , may i know how to share file with you ?
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 ?