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.
Hi,
Does anyone know how I can transform next table which is data source to the second table shown below.
This is my data source. As you can see, there are multiple rows referring to the sam transaction.
TransactionID | Name | Role | Locations |
001 | John Smith | Sales Person | New York |
001 | David Johnson | Manager | New York |
001 | Alex Berman | Buyer | New York |
002 | Mike Tomphson | Sales Person | Boston |
002 | Dan Jordan | Manager | Boston |
002 | Marko Black | Buyer | Boston |
I would like to transform this sourcing table in Power BI to the table below (based on the people's role from the first table, I want to create the new columns, so each transaction is shown just in one row). This is what I want to see in Power BI:
TransactionID | Sales Person | Manager | Buyer | Locations |
001 | John Smith | David Johnson | Alex Berman | New York |
002 | Mike Tomphson | Dan Jordan | Marko Black | Boston |
Please does anyone has an idea how to achieve this?
Many thanks!
Laki
Solved! Go to Solution.
Pivot the Roles column.
i
It works. Thank you!
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |