Forum Discussion

Moniek's avatar
Moniek
Icon for Resolver I rankResolver I
4 years ago
Solved

DAX Rolling total

Hi, I made a dax formula for the rolling total of Saldo. In the left table the formula is okay, but in the right table (that is the table that I want to make) is the rolling total not correct. How can I change the DAX, that I see in the right table the correct rolling total. Thanks!

 

 

Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    Hey Moniek ,

     

    If you are looking to add a new column in your visual, you will have to take that into consideration in your DAX.

    something like:

     

    CumulativeMeasure =
CALCULATE (
    [Saldo 1],
    FILTER (
        ALL ( ADF[DATUM] ),
        ADF[DATUM] <= MAX ( ADF[DATUM] )
    ),
    Table[Omschrijving] = MAX ( Table[Omschrijving] )
)

2 Replies

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hey Moniek ,

     

    If you are looking to add a new column in your visual, you will have to take that into consideration in your DAX.

    something like:

     

    CumulativeMeasure =
CALCULATE (
    [Saldo 1],
    FILTER (
        ALL ( ADF[DATUM] ),
        ADF[DATUM] <= MAX ( ADF[DATUM] )
    ),
    Table[Omschrijving] = MAX ( Table[Omschrijving] )
)