Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Accumulative Value in Line Chart

Hello there,   First of all, excuse me and my low skills on DAX. I have this "Earnings" column, and I need a Line chart where it shows an Accumulative version during time with the legend of the sh...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Ideal is datetime column and cumulative like

     

    sumx(filter(allselected(Table), Table[Datetime] <= Max(Table[Datetime])), Table[Earning])

     

    or

    sumx(filter(allselected(Table), Table[Datetime] <= Max(Table[Datetime]) && Table[ID] = max(Table[ID]) ) , Table[Earning])

Anonymous's avatar
Anonymous
Not applicable
4 years ago

When using the second design, the one with IDs, I get the chart above. And when I use the first one, I get the chart below with the value accumulating in all the shops at the same time.

 

I think I must add that each shop_id will appear more than once in the table, because you can buy something in one shop several times on several days.

 

What I'm trying to draw is one continuous accumulative line for each shop during that time period.

 

Sorry for all this bothering, and thank you for your time and patience!

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,  

 

I agree with amitchandak 's second code. I have a test by amitchandak 's code, and it will work in my sample. 

Could you share more details about your data model or share a sample file created by import mode with us? This will make it easier for us to find the solution.

 

Best Regards,
Rico Zhou

 

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