How to convert yearly bar chart to Accumulated bar chart ?

[admin11]

Hi All

I have below yearly expense , in 2019 amount 39 , 2020 amount 19 

i like to plot the chart in accumuate amount .

2019 will display 39 , and 2020 will display 39+19=58

i think 

AMOUNT_1 = SUM(GL[AMT])

should be change to 

AMOUNT_1 = ACCUMULATE(GL[AMT])

But it cannot work.

[Jihwan_Kim · Accepted solution]

Hi, @admin11 

Please correct me if I wrongly understood your question.

Please try the below.

accumulate measure = calculate (SUM(GL[AMT]) , filter (allselected (datetable), datetable[datecolumn] <= max(datetable[datecolumn])))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[admin11]

@Jihwan_Kim 

Thank you for your help. i get error , because those date field i don't know how to fill in.

@amitchandak 

Thank you very much , your work fine , but not sure why you delete your post ?

amount_int = calculate(SUM(GL[AMT]), filter(allselected(GL), GL[year]<=max(GL[year])))

Above code no error and working fine.

Paul

[Jihwan_Kim]

Hi,

I was not quite sure about how your date table looks like.

If you do not have date table connected, and your visualization is using Year Column from your main table, then the solution from Amitchandak would be correct.

Thank you.

[admin11]

@Jihwan_Kim  I did have master calendar table , @amitchandak know my data model very well . He is the one who have answer most of my post.