Forum Discussion

Tan_LC's avatar
Tan_LC
Icon for Helper II rankHelper II
2 years 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 othe...
Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years 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
Icon for Helper II rankHelper II
2 years 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
    Icon for Super User rankSuper User
    2 years 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.