https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-crosstab-with-rolling-sum/m-p/2592839#M74735 <P>Can someone please help me in creating a crosstab table where I can show rolling sums.</P><P>Below is how I want to show the corsstab in power BI visual&nbsp; and the table structure that I have.</P><P>I am trying to find a way to show 'Rolling 3 month Sales' I am flexible with the table structure and can change it if that makes the calculation easy.</P><P><img /></P> Tue, 21 Jun 2022 16:39:36 GMT Anonymous 2022-06-21T16:39:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-crosstab-with-rolling-sum/m-p/2592839#M74735 <P>Can someone please help me in creating a crosstab table where I can show rolling sums.</P><P>Below is how I want to show the corsstab in power BI visual&nbsp; and the table structure that I have.</P><P>I am trying to find a way to show 'Rolling 3 month Sales' I am flexible with the table structure and can change it if that makes the calculation easy.</P><P><img /></P> Tue, 21 Jun 2022 16:39:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-crosstab-with-rolling-sum/m-p/2592839#M74735 Anonymous 2022-06-21T16:39:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-crosstab-with-rolling-sum/m-p/2593035#M74746 <P>Anonymous</LI-USER>&nbsp;attached a file with how to solve this.<BR /><A href="https://spartabiltd-my.sharepoint.com/:u:/g/personal/avishayf_spartabi_com/Ea5TumbP-O9Jo2vaOEykKCUBOTKY4jeHWgvn2BPrm40WSw?e=zkTdND" target="_blank">CrossTab With Rolling Sum.pbix</A><BR /><BR /></P><P><BR /><img /></P><P><BR /><A href="https://www.spartabi.com" target="_blank" rel="noopener"><img /></A><BR /><BR /><A href="https://www.spartabi.com" target="_blank" rel="noopener"><img /></A>&nbsp;&nbsp;&nbsp;<A href="https://www.linkedin.com/company/spartabi" target="_blank" rel="noopener"><img /></A> &nbsp;&nbsp;<A href="https://www.facebook.com/SpartaBI" target="_blank" rel="noopener"><img /></A><BR /><BR /><A href="https://community.powerbi.com/t5/Data-Stories-Gallery/Contoso-by-SpartaBI/m-p/2449543" target="_blank" rel="noopener"><FONT size="4" color="#0000EE">Showcase Report – Contoso By SpartaBI</FONT></A></P> Tue, 21 Jun 2022 18:29:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/A-crosstab-with-rolling-sum/m-p/2593035#M74746 SpartaBI 2022-06-21T18:29:01Z