topic How to add previous month data to current month. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-previous-month-data-to-current-month/m-p/2746062#M84575 <P><SPAN>Hi everyone, I need a support. I have the production Ready HC data only for the month of Aug-22. Now, i need to find Production Ready HC for remaining months.&nbsp;<BR /><BR /><BR /></SPAN></P><P>The formula is (Manual Production Ready HC(Aug-22) + CH(Aug-22)= Production Ready HC (Sep-22). Same for remaining months, Previous month total should be current month production Ready HC. Please help, how to write a dax query for this scenario. Thanks in advance.</P><P><img /></P><P>&nbsp;</P><P><SPAN>&nbsp;</SPAN></P> Sun, 04 Sep 2022 13:59:18 GMT Anonymous 2022-09-04T13:59:18Z How to add previous month data to current month. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-previous-month-data-to-current-month/m-p/2746062#M84575 <P><SPAN>Hi everyone, I need a support. I have the production Ready HC data only for the month of Aug-22. Now, i need to find Production Ready HC for remaining months.&nbsp;<BR /><BR /><BR /></SPAN></P><P>The formula is (Manual Production Ready HC(Aug-22) + CH(Aug-22)= Production Ready HC (Sep-22). Same for remaining months, Previous month total should be current month production Ready HC. Please help, how to write a dax query for this scenario. Thanks in advance.</P><P><img /></P><P>&nbsp;</P><P><SPAN>&nbsp;</SPAN></P> Sun, 04 Sep 2022 13:59:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-previous-month-data-to-current-month/m-p/2746062#M84575 Anonymous 2022-09-04T13:59:18Z Re: How to add previous month data to current month. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-previous-month-data-to-current-month/m-p/2746076#M84577 <P>hi&nbsp;Anonymous</LI-USER>&nbsp;<BR />Please provide sample data to better understanding of the requirement and in oder to simulate a proper solution.&nbsp;</P> Sun, 04 Sep 2022 14:21:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-add-previous-month-data-to-current-month/m-p/2746076#M84577 tamerj1 2022-09-04T14:21:17Z