Pivot Expression.Error

Anonymous · ‎04-27-2018

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=<
Left=Record
Right=Record

Can someone please advice on how fix this issue?

Thank you,
Stavros

v-chuncz-msft · ‎04-29-2018

@Anonymous,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎04-30-2018

@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