How do you create a table and the values are accumulated?

[Anonymous]

i want to create a table which the values are accumlating (see sample below) but i could not get the correct visual to use. I hope you can help me on this.

PIVOT TABLE:

5/21/2018	1326	231
5/22/2018	12803	46105
5/23/2018	28641	7931
5/24/2018	34042
5/25/2018

The table i want to create in Power BI.

5/21/2018	1326	231
5/22/2018	14129	46336
5/23/2018	42770
5/24/2018	76812
5/25/2018	76812

[BhairavPalan · Accepted solution]

1. Check the format

2. It will solved using Cumm. Total

Cumulative Quantity :=

CALCULATE (SUM ( Transactions[Quantity] ),

    FILTER (ALL ( 'Date'[Date] ),

        'Date'[Date] <= MAX ( 'Date'[Date] )))

Hope this helps

[v-chuncz-msft]

@Anonymous,

You may simply use Quick measure Running total.

[Anonymous]

I already use the running total but it seems that the total on the previous date does not sum up the next one. It always shows the "count" instead.

[v-chuncz-msft]

@Anonymous,

Check the data type and do not select Date Hierarchy.