How can I make an cummulative calculation of the amounts ofassets with an specific value over time?

[lisannegesch]

Hi all,

I've a dataset with different columns:

- Asset

- Quantity of asset

- Date placed

- Details of the asset

Now I want to make a column that calculates the cummulative quantity of an asset with a specific detail. For example, I want to see how many assets are white based on the dates as well:

Could somewone help me?

[mangaus1111 · Accepted solution]

Hi @lisannegesch ,

try this calculated column, it works!

Column =

IF (

    'Table'[Details] = "white",

    CALCULATE (

        SUM ( 'Table'[quantity] ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[Date]

                <= EARLIER ( 'Table'[Date] )

                && 'Table'[Details] = "white"

        )

    ),

    BLANK ()

)

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

[v-luwang-msft]

Hi @lisannegesch ，

Use the dax like the below to create a new column:

Column = IF('Table'[Details]="white",CALCULATE(SUM('Table'[quantity]),FILTER(ALL('Table'),'Table'[Date]<=EARLIER('Table'[Date])&&'Table'[Details]="white")),BLANK())

Output result:

Best Regards

Lucien

[piotr_gor]

Try: 

CALCULATE( 
SUM('Table'[Quantity] ), 
ALL ('Table'),
'Table'[Details] = "white",
'Table'[Date] <= MAX( 'Table'[Date] ) 
)

[lisannegesch]

Thanks for your fast reply and help :).  I do get a calculation but it isn't cummulative (all the results are the same), it also shows results in the column where the detail isn't met.