Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |