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.
Hello, I have several week columns (over 200) for sales by state. I would like to know if there is an easy way to calculate these totals by row in another table. (similar to a pivot function in Excel)
Current table:
State W1 W2 W3 W4 . . .
TX 5 2 4 3
NM 1 3 5 4
AZ 7 2 1 5
Desired Table
Week # Total/Sum
W1 13
W2 7
W3 10
W4 12
. .
. .
. .
Solved! Go to Solution.
Hi @Anonymous
In the Query Editor, Select go to the Transform tab. Make sure you have the first column select and use the Unpivot other columns feature.
This should convert your data to the format below, which is ideal for building measures over.
Hi @Anonymous
In the Query Editor, Select go to the Transform tab. Make sure you have the first column select and use the Unpivot other columns feature.
This should convert your data to the format below, which is ideal for building measures over.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |