Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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.
@Anonymous attached a file with how to solve this.
CrossTab With Rolling Sum.pbix
@Anonymous attached a file with how to solve this.
CrossTab With Rolling Sum.pbix
User | Count |
---|---|
17 | |
17 | |
14 | |
12 | |
12 |
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
7 |