topic Re: how to calculate data and save in different table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4156761#M165180 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="808017" data-lia-user-login="PBX_user" class="lia-mention lia-mention-user">PBX_user</a>&nbsp;, Create a new table using DAX go to modelling and create new table and use Summarize</P> <P>&nbsp;</P> <P>SecondTable = <BR />SUMMARIZE(<BR />'FirstTable',<BR />'FirstTable'[Month],<BR />'FirstTable'[State],<BR />"No of Tasks", COUNTROWS('FirstTable')<BR />)</P> Wed, 18 Sep 2024 12:14:54 GMT bhanu_gautam 2024-09-18T12:14:54Z how to calculate data and save in different table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4156681#M165177 <P>I have a situation where I need to calculate data and save it in different table for reporting&nbsp;</P><P>Raw data&nbsp;</P><P><img /></P><P>&nbsp;</P><P>I want result in below format</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 18 Sep 2024 11:38:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4156681#M165177 PBX_user 2024-09-18T11:38:34Z Re: how to calculate data and save in different table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4156761#M165180 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="808017" data-lia-user-login="PBX_user" class="lia-mention lia-mention-user">PBX_user</a>&nbsp;, Create a new table using DAX go to modelling and create new table and use Summarize</P> <P>&nbsp;</P> <P>SecondTable = <BR />SUMMARIZE(<BR />'FirstTable',<BR />'FirstTable'[Month],<BR />'FirstTable'[State],<BR />"No of Tasks", COUNTROWS('FirstTable')<BR />)</P> Wed, 18 Sep 2024 12:14:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4156761#M165180 bhanu_gautam 2024-09-18T12:14:54Z Re: how to calculate data and save in different table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4157458#M165208 <P>Thank you&nbsp;<SPAN>bhanu_gautam that worked.</SPAN></P><P>I have different set of data as well, how I can create a result set of this data set&nbsp;</P><P>raw data:</P><P><img /></P><P>&nbsp;</P><P>Result needed as below:</P><P><img /></P><P>&nbsp;</P> Wed, 18 Sep 2024 16:26:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-calculate-data-and-save-in-different-table/m-p/4157458#M165208 PBX_user 2024-09-18T16:26:12Z