Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |