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 all,
I am reading an XML file with this shape
Using Power Query to Expand Label table (??Is it possible to expand and create 3 columns...instead 3 rows)
#"ExpandLable" = Table.ExpandTableColumn(Table0, "label", {"group", "text"}, {"label.group", "label.text"})
And Data is converted in this format... after expanding
Now I have data with this format ( in colours by group)
However now I need to get converted data in this format, in each group of 3 registers by Instance ID.
ID, start,end, code ,pos_x and pos_y are always the same value inside a group.
I tried several pivoting options with no ...luck
Regards
Solved! Go to Solution.
Hi @dpombal,
Please refer to the snapshot below.
1. Select the two columns "label.group" and "label.text".
2. Follow the steps in the snapshot.
Best Regards,
Dale
Hi @dpombal,
Please refer to the snapshot below.
1. Select the two columns "label.group" and "label.text".
2. Follow the steps in the snapshot.
Best Regards,
Dale
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |