Forum Discussion

streli's avatar
streli
Helper I
3 years ago

Cumulative sum in powerquery editor

Hi   I have 3 colums: a dataday, an expiry date column and a volumen column (you can see in the picture: each dataday has an expiry date and a unit value.) How can I calculate a cumulative amount ...
Need Help
Manoj_Nair's avatar
Manoj_Nair
Solution Supplier
3 years ago

streli- Check this out, if this works for you.

Cumulative Amount = 
CALCULATE(
    SUM('Table'[Volumen]),
    FILTER(
        ALL('Table'),
        'Table'[ExpiryDate] > MAX('Table'[DataDay])
    )
)