Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge Queries Expand - Ends with Expression.Error cannot apply operator & to types Number and Number

Hi,   How is it possible that my merge query ends with the above mentioned error? I understand that error when creating custom columns but this is new to me. The reference in the error (see details...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    I solved the problem.

     

    The Query which caused the problem was initially appended from two other queries with the same columns but I haven't had removed the PBI's automatic "Changed type" step which is why the other one of the appended queries still had some Number formated columns. After I changed those columns to text (or actually just removed the automatic Changed type) this whole process worked.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I solved the problem.

 

The Query which caused the problem was initially appended from two other queries with the same columns but I haven't had removed the PBI's automatic "Changed type" step which is why the other one of the appended queries still had some Number formated columns. After I changed those columns to text (or actually just removed the automatic Changed type) this whole process worked.