Cannot create a column by searching for values in another table

[DevadathanK]

Hello community!

<Message removed>

Thanks for any help!

[Greg_Deckler]

Have you tried LOOKUPVALUE?https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

[DevadathanK]

I did, but i keep getting stcuk at one point.

In the latest LOOKUPVALUE used in the above code, the search column should be Employee ID, but it wont let me choose that option.

[DevadathanK]

I managed to work around the issue that didnt let me pick EMPLOYEE ID, and managed to complete the code, but i cant seem to narrow down the Looked up value to a single value. There are multiple Leaves taken in a single week, so LOOKUPVALUE will return a table of values and not a single one.

The Error states "A table of multiple values was supplied where a single value was expected"

Is there anyother way to do this code other than LOOKUPVALUE? Or is there something that i missed to use along with LOOKUPVALUE?

[DevadathanK]

I removed the multiple leaves that were coming in a single week. Now this code works. 

Employee ID	Employee Name	Leave From Date	Leave To Date	From Week No.	To Week No.	Days
1001	Miss. O	1-Jan-20	1-Jan-20	1	1	1
1007	Mr. K	2-Jan-20	3-Jan-20	1	1	2
1009	Mr. J	2-Jan-20	15-Jan-20	1	3	10

But the ideal solution is to incorportate any scenario, and this code will fail in other situations.