Forum Discussion
Solved
Cumulative Chart
Hi All I would like to have chart where cumulative value for the current financial year (Opening balance should be added to first month and each month previous month value should be added) , plea...
try this measure:
Net value running total in Month =
CALCULATE(
SUM('TABLE'[Net value]),
FILTER(
CALCULATETABLE(
SUMMARIZE(
'TABLE',
'TABLE'[Created on].[MonthNo],
'TABLE'[Created on].[Month]
),
ALLSELECTED('TABLE')
),
ISONORAFTER(
'TABLE'[Created on].[MonthNo], MAX('TABLE'[Created on].[MonthNo]), DESC,
'TABLE'[Created on].[Month], MAX('TABLE'[Created on].[Month]), DESC
)
)
)you will then have to adjust your Area Chart as follow:
reusults:
- Hi Minseven Thank you for the reply, I have been trying this for few days, i could not recreate as you did, could you please send me a sample Pbix file, Thanks in Advance Regards Jayanthan
