https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2663499#M79058 <P>Thanks Jihwan! this works brillantly!</P> Wed, 27 Jul 2022 01:45:40 GMT Anonymous 2022-07-27T01:45:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2660592#M78875 <P>Hi All,<BR /><BR />I encountered issues in projecting the correct cumulative figure.<BR />Anyone able to figure what is wrong?<BR /><BR /></P><P><img /><BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 26 Jul 2022 02:54:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2660592#M78875 Anonymous 2022-07-26T02:54:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2660606#M78877 <P>Hi,</P> <P>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?&nbsp;</P> Tue, 26 Jul 2022 03:07:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2660606#M78877 Jihwan_Kim 2022-07-26T03:07:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2663499#M79058 <P>Thanks Jihwan! this works brillantly!</P> Wed, 27 Jul 2022 01:45:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-total-is-showing-wrong-calculation/m-p/2663499#M79058 Anonymous 2022-07-27T01:45:40Z