Forum Discussion

Tan_LC's avatar
Tan_LC
Helper II
1 year ago

Summarize Horizontable Table into Vertical Table

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:

DateMachineProduct No.Cap_BaseCap_WindCap_TurretBelt_1Belt_2Belt_TurretBand_1Band_ILSW_Apply
28/08/20241A56658335556078427290
29/08/20242M74507082452371648473
30/08/20243B83334856404191698999

 

 

After:

DateMachineProduct No.SectionElementValue
28/08/20241A56CPCap_Base65
28/08/20241A56CPCap_Wind83
28/08/20241A56CPCap_Turret35
28/08/20241A56BLBelt_155
28/08/20241A56BLBelt_260
28/08/20241A56BLBelt_Turret78
28/08/20241A56BNBand_142
28/08/20241A56BNBand_IL72
28/08/20241A56BNSW_Apply90
29/08/20242M74CPCap_Base50
29/08/20242M74CPCap_Wind70
29/08/20242M74CPCap_Turret82
29/08/20242M74BLBelt_145
29/08/20242M74BLBelt_223
29/08/20242M74BLBelt_Turret71
29/08/20242M74BNBand_164
29/08/20242M74BNBand_IL84
29/08/20242M74BNSW_Apply73
30/08/20243B83CPCap_Base33
30/08/20243B83CPCap_Wind48
30/08/20243B83CPCap_Turret56
30/08/20243B83BLBelt_140
30/08/20243B83BLBelt_241
30/08/20243B83BLBelt_Turret91
30/08/20243B83BNBand_169
30/08/20243B83BNBand_IL89
30/08/20243B83BNSW_Apply99

 

Thank you.

 

Regards,

LC

3 Replies

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    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's avatar
      Tan_LC
      Helper II
      1 year ago

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

       

      Thank you.

      • Irwan's avatar
        Irwan
        Super User
        1 year ago

        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.