Summarize Horizontable Table into Vertical Table

[Tan_LC]

Hi, kindly assist as below:

1. Value from column "Cap_Base" until "SW_Apply" to be transposed from horizontal to vertical using DAX.

2. Any other method of grouping the Element into Section other than using IF function?

Before:

Date	Machine	Product No.	Cap_Base	Cap_Wind	Cap_Turret	Belt_1	Belt_2	Belt_Turret	Band_1	Band_IL	SW_Apply
28/08/2024	1	A56	65	83	35	55	60	78	42	72	90
29/08/2024	2	M74	50	70	82	45	23	71	64	84	73
30/08/2024	3	B83	33	48	56	40	41	91	69	89	99

After:

Date	Machine	Product No.	Section	Element	Value
28/08/2024	1	A56	CP	Cap_Base	65
28/08/2024	1	A56	CP	Cap_Wind	83
28/08/2024	1	A56	CP	Cap_Turret	35
28/08/2024	1	A56	BL	Belt_1	55
28/08/2024	1	A56	BL	Belt_2	60
28/08/2024	1	A56	BL	Belt_Turret	78
28/08/2024	1	A56	BN	Band_1	42
28/08/2024	1	A56	BN	Band_IL	72
28/08/2024	1	A56	BN	SW_Apply	90
29/08/2024	2	M74	CP	Cap_Base	50
29/08/2024	2	M74	CP	Cap_Wind	70
29/08/2024	2	M74	CP	Cap_Turret	82
29/08/2024	2	M74	BL	Belt_1	45
29/08/2024	2	M74	BL	Belt_2	23
29/08/2024	2	M74	BL	Belt_Turret	71
29/08/2024	2	M74	BN	Band_1	64
29/08/2024	2	M74	BN	Band_IL	84
29/08/2024	2	M74	BN	SW_Apply	73
30/08/2024	3	B83	CP	Cap_Base	33
30/08/2024	3	B83	CP	Cap_Wind	48
30/08/2024	3	B83	CP	Cap_Turret	56
30/08/2024	3	B83	BL	Belt_1	40
30/08/2024	3	B83	BL	Belt_2	41
30/08/2024	3	B83	BL	Belt_Turret	91
30/08/2024	3	B83	BN	Band_1	69
30/08/2024	3	B83	BN	Band_IL	89
30/08/2024	3	B83	BN	SW_Apply	99

Thank you.

Regards,

LC

[Irwan]

hello @Tan_LC 

this would be much easier with Power Query.

your data has already been grouped by machine and product number however if you need to define another grouping, then IF or SWITCH will be useable.

Hope this will help.
Thank you.

[Tan_LC]

@Irwan I've tried using Power Query previously and it fails to load the data as my data is huge.

Thank you.

[Irwan]

hello @Tan_LC 

i am not sure if you want to do with DAX then.

based on my experience, if Power Query couldnt handle it, DAX might face same difficulties as well. 

since the data is huge, then you might be needed to filter your data or check your hardware.

Thank you.