Convert table in dataset

Question

I need from that tableItem_nameSupplier_nameTotal 12 month2022_012022_022022_032022_042022_052022_061,2- (8250066) /KG/ООО&nbsp; (8008769)0000000&nbsp;made this&nbsp;Item_nameSupplier_nameDateAmaunt1,2- (8250066) /KG/ООО&nbsp; (8008769)Total 12 month01,2- (8250066) /KG/ООО&nbsp; (8008769)2022_0101,2- (8250066) /KG/ООО&nbsp; (8008769)2022_0201,2- (8250066) /KG/ООО&nbsp; (8008769)2022_0301,2- (8250066) /KG/ООО&nbsp; (8008769)2022_0401,2- (8250066) /KG/ООО&nbsp; (8008769)2022_0501,2- (8250066) /KG/ООО&nbsp; (8008769)2022_060&nbsp;May be there is a solution script...may be on python

themistoklis · Accepted Answer

Nick_2510&nbsp;
&nbsp;
You should use UnPivot in Power Query.
See links below:
https://www.newtechdojo.com/unpivot-columns-in-power-bi/
https://databear.com/power-bi-pivot-and-unpivot-columns/
&nbsp;

Forum Discussion

Convert table in dataset

1 Reply

Related content

Converting a Table

Refresh dataset api

Convert jotfom data to table

Convert Excel columns into rows in a PBI table

Converting to Percentage

Item_name	Supplier_name	Total 12 month	2022_01	2022_02	2022_03	2022_04	2022_05	2022_06
1,2- (8250066) /KG/	ООО (8008769)	0	0	0	0	0	0	0

Item_name	Supplier_name	Date	Amaunt
1,2- (8250066) /KG/	ООО (8008769)	Total 12 month	0
1,2- (8250066) /KG/	ООО (8008769)	2022_01	0
1,2- (8250066) /KG/	ООО (8008769)	2022_02	0
1,2- (8250066) /KG/	ООО (8008769)	2022_03	0
1,2- (8250066) /KG/	ООО (8008769)	2022_04	0
1,2- (8250066) /KG/	ООО (8008769)	2022_05	0
1,2- (8250066) /KG/	ООО (8008769)	2022_06	0