Forum Discussion
DevadathanK
Resolver I
Resolver ICannot create a column by searching for values in another table
Hello community!
<Message removed>
Thanks for any help!
4 Replies
- Greg_Deckler
Community Champion
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?
