Forum Discussion

Eng-mohd's avatar
Eng-mohd
Helper I
2 years ago
Solved

Like lookup

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 f...
Need Help
  • Kishore_KVN's avatar
    Kishore_KVN
    2 years ago

    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!!

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
2 years ago

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!!