Forum Discussion
Show acumulated values
- Anonymous9 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
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
Anonymous this is great!
Thank you very much!