Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

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/20181326231
5/22/20181280346105
5/23/2018286417931
5/24/201834042 
5/25/2018  

 

The table i want to create in Power BI.

 

5/21/20181326231
5/22/20181412946336
5/23/201842770 
5/24/201876812 
5/25/201876812 
  • BhairavPalan's avatar
    BhairavPalan
    8 years ago

    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

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        v-chuncz-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Anonymous,

         

        Check the data type and do not select Date Hierarchy.

  • BhairavPalan's avatar
    BhairavPalan
    Regular Visitor
    8 years ago

    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