Forum Discussion

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost Patron
3 years ago

Running Total not working properly

Hi Guys,   impossible to create a running total working properly.   I have made a summarized table based on the movement table i have.   Here the formula and the result (filtered on a ref for ...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please try something like below to create a new column.

 

Running total CC =
SUMX (
    FILTER (
        'Calculs images de stock',
        'Calculs images de stock'[DATE PIECE]
            <= EARLIER ( 'Calculs images de stock'[DATE PIECE] )
    ),
    'Calculs images de stock'[Mouvements de stock]
)
  • SebSchoon1's avatar
    SebSchoon1
    Icon for Post Patron rankPost Patron
    3 years ago

    hello,

     

    Jihwan_Kim i think that earlier will explode my power bi ^^ i have 12 million records 🙂