Forum Discussion
Lookup Value Blank Result
Hi,
Hope someone can resolve my inquiry, I used dax function lookupvalue() but the results are all blanks.
I need to get their supervisor email in resource table the lookup reference should be Resource[Employee_ID] and Workday[Supervisor] both of them are whole number data types.
But it shows blank per each rows.
Hope can share with me an idea or other approach to get their right supervisor email address.
This is created to new column, I need to create column for their supervisor email address base on their supervisor ID.
WorkdayReport Table:
ResourceTable: (I didn't ss email address because the column was too many.)
This table I need to get the supervisor email address.
1 Reply
- lbendlin
Super User
Use TREATAS() instead of LOOKUPVALUE.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
