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
User | Count |
---|---|
105 | |
31 | |
25 | |
18 | |
15 |
User | Count |
---|---|
101 | |
22 | |
20 | |
18 | |
17 |