Forum Discussion

Frequent Visitor

3 years ago

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...

3 years ago

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])

Ashish_Mathur
3 years ago
File attached. See signature.
MFG Fixed Cost Testing.pbix165 KB

Super User

3 years ago

Hi,

Share the download link of the PBI file and show the expected result.

Frequent Visitor

3 years ago

Ashish_Mathur , may i know how to share file with you ?

Ashish_Mathur
Super User
3 years ago
Hi,

Upload the file to Google Drive and share the download link here. Show the expected result very clearly.
- RLOH
  Frequent Visitor
  3 years ago
  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)
  https://docs.google.com/spreadsheets/d/1clhCuyMR2UQFCjbVjCz3GXHzkFu4ABtu/edit?usp=share_link&ouid=108866791626726295686&rtpof=true&sd=true
  - Ashish_Mathur
    Super User
    3 years ago
    Hi,
    
    See if my solution here helps.