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! I would like to transform a table. Is it possible based on the information provided below?
Here is my current table - notice there are two unique users that belong to the 'North' Division.
I would like to the table to look like this:
The goal of the transformation is to take the 'Division' column which contains duplicates (because of multiple people belonging to that Division) and instead have a unique list. Then for each additional 'Authorized User' beyond 1, a new column would be created as needed (Authorized User2, Authorized User3, etc.).
Is this possible?
Solved! Go to Solution.
1) Add Column tab - Add Index From Zero
2) Transform Tab - Standard dropdown - Modulo - enter 2 in the dialog
3) select Index Column - Pivot Column - Values Column - select Authorized User - Advanced Options - Do Not Aggregate
4) Rename the 2 new columns
1) Add Column tab - Add Index From Zero
2) Transform Tab - Standard dropdown - Modulo - enter 2 in the dialog
3) select Index Column - Pivot Column - Values Column - select Authorized User - Advanced Options - Do Not Aggregate
4) Rename the 2 new columns
Hi @Sean.
Аctually this model works only if there is no more than two values for one parameter. If there are three or more values, then the appropriate number of values should be set in Modulo. And this is not convenient if the data is updated.
This worked perfectly!!
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 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |