Solved: Cumulative total is showing wrong calculation

cbabel14 · ‎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.

Go to My LinkedIn Page

View solution in original post

cbabel14 · ‎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.

Go to My LinkedIn Page

Cumulative total is showing wrong calculation

Helpful resources

Power BI September 2023 Update

Learn Live: Event Series

Exclusive opportunity for Women!

Power Platform Conference-Power BI and Fabric Sessions