Forum Discussion

chrisgehm's avatar
chrisgehm
Icon for Helper III rankHelper III
9 years ago
Solved

Show acumulated values

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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