Pivot Expression.Error

[Anonymous]

Hello all,

I am trying to pivot two columns, using the do not aggregate value funtion.

However, I get back the following error:

Expression.Error: We cannot apply operator < to types Record and Record.
Details:
Operator=&lt;
Left=Record
Right=Record

Can someone please advice on how fix this issue?

Thank you,
Stavros

[v-chuncz-msft]

@Anonymous,

Tables with nested columns are not supported. You'll need to expand a column of records into columns first.

[Anonymous]

@v-chuncz-msft

Thank you for your reply. I was thinking something similar, however, I am not am not given the option to expand any of the columns that I am selecting. I am only selecting data columns. Please see video attached.

Thank you again for your reply and I am looking forward to hearing from you.

Regards,

Stavros

https://we.tl/KFCARKT1EO