Like lookup

[Eng-mohd]

• How to search for a value from one column and search for it in another column, and when found, take a value from a third column next to it

I wana make new column with the value from 3thrd if its found 

If not return 0

[Kishore_KVN · Accepted solution]

Hello @Eng-mohd , let me explain with a example. I have two tables, Table 2 and Table 3 and their data is a below:

Table 2:

Table 3:

I am now trying to get FTE from Table 3 to Table 2 using Location Name as reference and LOOKUPVALUE DAX function. So calculation looks as below:

FTE'S = LOOKUPVALUE('Table 3'[FTE],'Table 3'[Location Name],'Table 2'[Location Name])

Output looks as below:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Idrissshatila]

Hello @Eng-mohd ,

Yes, you can use the lookup value dax function https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡