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 data that looks like this
ID|First|Last|Purchase|Date
333|John|Doe|Truck|January
444|Jane|Smith|Car|January
333|John|Doe|Car|February
333|John|Doe|Tractor|March
444|Jane|Smith|Truck|April
I would like for all of the information about John Doe and Jane Smith to be in 1 row but in all separate columns.
Thanks!
Solved! Go to Solution.
You just need to select Pivot Column in Query Editor or use a Matrix visual.
You just need to select Pivot Column in Query Editor or use a Matrix visual.
I have data that looks like this
ID|First|Last|Purchase|Date
333|John|Doe|Truck|January
333|John|Doe|Car|February
333|John|Doe|Tractor|March
I would like for all of the information about John Doe to be in 1 row but in all separate columns.
Thanks!
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 |