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 othe...
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.