Forum Discussion
Convert data lay out
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 |
Hi Anonymous,
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
2 Replies
Hi Anonymous,
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