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.
Solved! Go to Solution.
@guptav13 attached a file with how to solve this.
CrossTab With Rolling Sum.pbix
@guptav13 attached a file with how to solve this.
CrossTab With Rolling Sum.pbix
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!