topic Re: Summarize Horizontable Table into Vertical Table in DAX Commands and Tips

Summarize Horizontable Table into Vertical Table

Tan_LC — Mon, 02 Sep 2024 04:13:05 GMT

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:

After:

Thank you.

Regards,

Irwan — Mon, 02 Sep 2024 04:21:32 GMT

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 — Mon, 02 Sep 2024 04:22:46 GMT

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

Thank you.

Irwan — Mon, 02 Sep 2024 04:33:00 GMT

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.