Show acumulated values

[chrisgehm]

Hi!

I've got the following table in excel:

What I need to do is to show in a line chart graph the 3 amounts.

But the first must be accumulated, for example:

In month 1 I've got 54 (4+46+4)

In month 2 Iv'e got 91 (1+89+1) but in the chart month 2 must have the value of month 1 + month 2 : 54+91=145. And so on, in Month 3 = month 2 + month 3

Month 4 = month 3 + month 4

etc..

Is it possible?

Do I have to do something in the excel file or directly in power bi?

Kind regards

[magsod · Accepted solution]

Hi,

One way to do this would be to create three separate measures in Power BI with the following code:

Measure1=Calculate(Sum('TableName'[Amount1]);
                                  Filter(All('TableName'[Month]);
                                           'TableName'[Month]<=MAX('TableName'[Month])
                                   )
                        )

Substitute 'TableName' with the name that your table has when imported into Power BI.

Then Measure2, Measure3 similar but use columns Amount2, 3...

Create the visual by adding a line chart and put Month on Axis and the three measures in Values.

Br,

Magnus

[chrisgehm]

@magsod this is great!

Thank you very much!