Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Ungroup a Running total

Hello everyone. I have the following data: FLVR ITEM_SAP Fecha Semana #Semana Calculo INV final CHOCOLATE 300033915 10/09/2022 0 547 CHOCOLATE 300033915 17/09/2022 1 177 CHO...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi Anonymous ,

     

    Please try this:

     

     

    INV final =
CALCULATE (
    SUM ( 'Table'[Calculo INV final] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[FLVR], 'Table'[ITEM_SAP] ),
        [#Semana] <= MAX ( 'Table'[#Semana] )
    )
)

     

     

    result:

     

     

    Pbix in the post you created 

    Suma acumulada con una agrupación de datos - Microsoft Power BI Community

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
3 years ago

Hi Anonymous ,

 

Please try this:

 

 

INV final =
CALCULATE (
    SUM ( 'Table'[Calculo INV final] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[FLVR], 'Table'[ITEM_SAP] ),
        [#Semana] <= MAX ( 'Table'[#Semana] )
    )
)

 

 

result:

 

 

Pbix in the post you created 

Suma acumulada con una agrupación de datos - Microsoft Power BI Community

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.