Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued Contributor
2 years ago
Solved

Running Balance DAX Formula

Hello everyone, I hope you're doing well. I have a question regarding creating a running balance DAX formula using a specific data table.   I'm working with a data table that includes columns for ...
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    2 years ago

    Hi ronaldbalza2023 

    Create a dates table, relate that to your fact table and create this sample measure.

    Cumulative Total Revenue = 
CALCULATE (
    [Total Revenue],
    FILTER ( ALL ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) )
)

    Please see attached pbix for details.

  • danextian's avatar
    danextian
    2 years ago

    hi ronaldbalza2023 ,

     

    Did you use a separate dates table as suggested? On top of that, you must use the date column from that dates table as the filter modifier ,  ALL (  Dates ), is applied to that table.

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

hi ronaldbalza2023 ,

 

Did you use a separate dates table as suggested? On top of that, you must use the date column from that dates table as the filter modifier ,  ALL (  Dates ), is applied to that table.