Forum Discussion
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 found
If not return 0
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!!
2 Replies
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💡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!!
