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
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

How did you get on with the link I posted above?

JohnF5343's avatar
JohnF5343
Regular Visitor
4 years ago

Not very far. 🙂

I tried the following but still get an error. 

Org 1 Email = 
LOOKUPVALUE (
    'Table'[EmployeeEmail],
    'Table'[EmployeeID], FORMAT( PATHITEM ( 'Table'[OrgH], 1, 1 ),"")
)

 

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Why are you trying to use FORMAT?  The 3rd parameter of PATHITEM defines the return type.

    "If missing or TEXT or 0 then this function returns a string. If INTEGER or 1 then this function returns an integer."

    The LOOKUPVALUE that doesn't work is using PATHITEM with a 1 in the 3rd parameter.  Try the other option.

    • JohnF5343's avatar
      JohnF5343
      Regular Visitor
      4 years ago

      Ok, all good. 

      Org 1 Email = 
LOOKUPVALUE (
    resources_cntrl[email],
    resources_cntrl[number], PATHITEM (resources_cntrl[OrgH], 1, 0 )
)

      Used a zero instead.