Forum Discussion

joginderpandha's avatar
joginderpandha
Frequent Visitor
8 years ago

Pivot Columns

I'm trying to Pivot a column (Milestone) with it's three values, Iniation, Deployment and Design being column headers and the Pivot Column value being another column called Planned Date.

 

I've highlighted the Milestone column, clicked Transform > Pivot Column. Chosen Planned Date as the value and chosen the Aggregate value function as Minimum. 

 

I get the following error:

 

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

 

Has anyone seen this before?

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi joginderpandha,

     

    Could you post your table structures with some sample/mock data which can help us reproduce the issue, so that we can better assist on it?

     

    It's better to just share a dummy pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    In addition, here is a similar thread for your reference. :smileyhappy:

     

    Regards