Forum Discussion

JohnF5343's avatar
JohnF5343
Regular Visitor
4 years ago
Solved

Function 'LOOKUPVALUE' does not support comparing values of type Text with values of type Integer.

Hi,  I'm creating a new column in a table with following DAX. All the columns in the DAX are text. The number column has the following format example: TWD123, SalesOrgH has the following format ...
Need Help
  • JohnF5343's avatar
    JohnF5343
    Regular Visitor
    4 years ago

    Hi, 

     

    So I have 2 tables in the pbix, the SalesPerson table works fine with whole numbers in the employee id column. With the other table, I get an error message. Could you have a look please? Pbix file