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.
Good day all, I have the following question.
Below is table_1.
I want to convert that table in the lay out of table_2.
Is there any option in Power BI to do so?
Thanks for your kind assistance, John
table_2
Equipment No | Mode 43 | WorkOrder No mode 43 | VendorRef No mode 43 | Mode 49 | WorkOrder No mode 49 | VendorRef No mode 49 |
CNIU2212712 | 40,13 | 70475555 | 0080505820 | 14,38 | 70475778 | 0080505830 |
CNIU2214850 | 14,38 | 70499772 | 0087328110 | |||
CNIU2214989 | 59,13 | 70593778 | 0087324030 |
table_1
Mode | Equipment No | Total | WorkOrder No | VendorRef No |
43 | CNIU2212712 | 40,13 | 70475555 | 0080505820 |
49 | CNIU2212712 | 14,38 | 70475778 | 0080505830 |
49 | CNIU2214850 | 14,38 | 70499772 | 0087328110 |
43 | CNIU2214989 | 59,13 | 70593778 | 0087324030 |
Solved! Go to Solution.
Hi @jwi1,
Please download the demo from the attachment. You can click or double-click the "Applied steps" to see the details. BTW, this may not be a good idea. What if there are thousands of Modes?
=[Attribute] & " " & Text.From([Mode])
Best Regards,
Dale
Hi @jwi1,
Please download the demo from the attachment. You can click or double-click the "Applied steps" to see the details. BTW, this may not be a good idea. What if there are thousands of Modes?
=[Attribute] & " " & Text.From([Mode])
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |