Forum Discussion

amiller5's avatar
amiller5
Icon for Helper II rankHelper II
4 years ago
Solved

Returning a value from a lookup value formula

I have 2 different files - they are connected in relationships by Account name but there may be multiple account names in the "Service 3 - Opps" file.  This is the column measure I have started:  ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Try this

    =if(isblank(LOOKUPVALUE('Service 3 - Contract Opps'[Account Name],'Service 3 - Contract Opps'[Account Name], 'Service 4 - Contract accts'[Account Name])),0,1)

    Hope this helps.

amiller5's avatar
amiller5
Icon for Helper II rankHelper II
4 years ago

This works but it brings in the lookup value text of the account name. I want to create a column where if the name appears in the other table, it gets a value of 1.00 and if not, it get a value of 0.00.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Try this

=if(isblank(LOOKUPVALUE('Service 3 - Contract Opps'[Account Name],'Service 3 - Contract Opps'[Account Name], 'Service 4 - Contract accts'[Account Name])),0,1)

Hope this helps.