cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
guptav13
Frequent Visitor

A crosstab with rolling sum

Can someone please help me in creating a crosstab table where I can show rolling sums.

Below is how I want to show the corsstab in power BI visual  and the table structure that I have.

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.

Capture.PNG

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

1 REPLY 1
SpartaBI
Community Champion
Community Champion

@guptav13 attached a file with how to solve this.
CrossTab With Rolling Sum.pbix


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors