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 Community!!
I have the following table that shows for each ID a number of serials (every ID has between 1 and 5 serials):
I need to run a transformation so I get a table with one column that contains all serials (from the 5 serials columns, but all in one column) and for each serial the ID. Each serial will be unique, but the same ID can appear for more than one serials (for cases where currently the ID has more than 1 serial, as the ID 12863 in the example).
Any ideas of how to do this?
Thanks!!!
Solved! Go to Solution.
Hi @Anonymous
You can select all your Serial columns and goto Transform Ribbon and Click Unpivot
Hi @Anonymous ,
Not sure if understand exactly what you are asking, but try this from the bottom picture. Original table, then convert data type to text if not already done, then create custom column using &, then delete all but the first and the last.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous
You can select all your Serial columns and goto Transform Ribbon and Click Unpivot
Perfect! 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 |
---|---|
101 | |
45 | |
19 | |
13 | |
11 |