Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with running total

I am atemting to get a running total from the start of wnd of 2019 to the current date. Included is a picture of my dax code that is not currently working. Thanks!

 

DAX
Help
Help Requested
  • Anonymous's avatar
    Anonymous
    4 years ago

    I was able to fix it by making a my own date table and using this code:

    Total Revenue running total in Quarter =
    CALCULATE(
        SUM('Matt-DataForBI'[Total Revenue]),
        FILTER(
            ALLSELECTED('Date'[Quarter]),
            ISONORAFTER('Date'[Quarter], MAX('Date'[Quarter]), DESC)
        )
    )

6 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    Does it help at all if you replace the ISONORAFTER line with the following?

    'Matt-DataForBI'[Date Closed] <= MAX ( 'Matt-DataForBI'[Date Closed] )

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I tried that an unfortentetly it doesnt. 

      • AlexisOlson's avatar
        AlexisOlson
        Icon for Super User rankSuper User
        4 years ago

        Hmm. What if you replace ALLSELECTED ( 'Matt-DataForBI'[Date Closed] ) with ALLSELECTED ( 'Matt-DataForBI' )?

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    You need to add a Date table [Calendar Table] to your report.
    To work with Data Analysis Expressions (DAX) time intelligence functions, there's a prerequisite model requirement: You must have at least one date table in your model.

     

    Check this link:

    https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/