Solved: Re: Cumulative total is showing wrong calculation

Anonymous · ‎07-25-2022

Hi All,

I encountered issues in projecting the correct cumulative figure.
Anyone able to figure what is wrong?

Jihwan_Kim · ‎07-25-2022

Hi,

I am not sure without seeing your data model, but could you please try to use [month number] column in your measure instead of using [month year name] column?

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

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

Anonymous · ‎07-26-2022

Thanks Jihwan! this works brillantly!

Jihwan_Kim · ‎07-25-2022

Hi,

I am not sure without seeing your data model, but could you please try to use [month number] column in your measure instead of using [month year name] column?

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

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.