Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
am using LOOKUPVALUE to find who owners are in a ticketing system based on information we draw from a report. The LOOKUP DAX is Below that I am using and some sample data. The issue is that one of the cells contain multiple names where only one of those, even separated by commas, are returning blank. What other options do I have to recieve the correct Result?
RES7 = IF(SELECTEDVALUE('IS Service Request - Data List'[Home Team])="Apps North America",LOOKUPVALUE('Home Team Owners 3'[Owners],'Home Team Owners 3'[Owners],SELECTEDVALUE('IS Service Request - Data List'[Assignments])),BLANK())
Columns with Data
Home Team Assignments
Apps North America Dale Durham, Joe Hancock, Mike nunley
Apps North America Steve Romano
Apps North America Marvin Taylor
Columns with Awnsers
Owners
Dale Durham
Marvin Taylor
Steve Romano
Results
BLANK() -------> How do I get Dale Durham to show up here?
Steve Romano
Marvin Taylor
Any Help on this would be great. I'm not the best programmer.
Solved! Go to Solution.
I split the column data with a delimiter as a comma and over 10 Columns. Then I used a measure to reconcile the data and grab the correct Answer.
Thank you for all your help.
Sincerely,
Nick Patel
Hi @Anonymous,
am using LOOKUPVALUE to find who owners are in a ticketing system based on information we draw from a report. The LOOKUP DAX is Below that I am using and some sample data. The issue is that one of the cells contain multiple names where only one of those, even separated by commas, are returning blank. What other options do I have to recieve the correct Result?
LOOKUPVALUE is not suitable for your scenario, I suggest you may try with Search function or Find Funtion.
Best Regards,
Cherry
Since I am using a column (Owners) to find the names within all of the cells. This would not work since the functions that you suggested only search for the parameters of specific word(s) or phrases and return them.
I split the column data with a delimiter as a comma and over 10 Columns. Then I used a measure to reconcile the data and grab the correct Answer.
Thank you for all your help.
Sincerely,
Nick Patel
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |