Forum Discussion
Solved
Calculated table with columns based on the values from another table
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
Pivot the Roles column.
i
