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.
Greg_Deckler , i also have another question related to this running total. Now that i have created new measure for running total which is the actual year-to-date number, i have another column called "Plan YTD" and i want to subtract Plan Ytd from this actual year-to-date number. When i use the Calculate DAX and try to find the column , there is no such column ..... so can i actually subtract the new created measure ?
Hi,
Share the download link of the PBI file and show the expected result.
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.