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 ...
  • 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