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.
I have the following table (as result of many steps) :
I want to get a result as below : as I need to transpose the table :
Solved! Go to Solution.
If data for the next country are below the shown data in the same column you can use this approach.
- Add an index column starting at 1
- Divide that column by the # of rows of data per country (19 shown) and round up to the nearest integer. You should get the same integer for all rows for the same country
- Highlight the first column and choose pivot column on the transform tab
- in the pop up choose the 2nd column for the Values and in the pull down choose no aggregation
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
If data for the next country are below the shown data in the same column you can use this approach.
- Add an index column starting at 1
- Divide that column by the # of rows of data per country (19 shown) and round up to the nearest integer. You should get the same integer for all rows for the same country
- Highlight the first column and choose pivot column on the transform tab
- in the pop up choose the 2nd column for the Values and in the pull down choose no aggregation
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |