Search and Return a Value from a Column.

[Anonymous]

Hi I'm looking at returning a value from a specific column where a value is matched between these.  See below.  Please help!

Column we are looking for these names in.

Assignments

S Bailey, D Durham

D Durham, C Morris

D Smathers, J Wade, R Beaudoin

D Cottle, M Taylor, S Evans, R Hayes

L McClain, Team: IS Purchasing/ Finance

D Druham, J Morrison, M Mullins

L McClain, Team: IS Purchasing/ Finance

D Smathers, Team: Apps Asia Pac

Column where the answers are

D Durham

D Smathers

D Cottle

F Michael

L McClain

M Towne

P Cruise

S Romano

I need this to retun the Names in th answers column. They are in separate tables, but relationships are built. How do I do this?

Thank you!!!

[Greg_Deckler]

I am not quite getting this. Do the two tables below represent your source data tables? 

[Anonymous]

This is what I have tries (Mulitiple Variations) but the commas make it very difficult.

Measure =
IF (
[RES3] = "Marvin Taylor"
&& 'IS Service Request - Data List'[ALL NAM Blanks] = "Apps North America",
SUBSTITUTE (
SELECTEDVALUE ( 'IS Service Request - Data List'[Assignments], BLANK () ),
",",
" "
)
&& LOOKUPVALUE (
'Apps North America'[Owner Name],
'Apps North America'[Owner Name], SELECTEDVALUE ( 'IS Service Request - Data List'[Assignments], BLANK () )
),
BLANK ()
)

[v-jiascu-msft]

Hi Nick,

If I want to test and work out a solution, how can I create the relationship?

Can you share a complete sample please? A dummy pbix file would be great.

Just see from both of the second row, how can we get "D Smathers" from "D Durham, C Morris"?

Best Regards,

Dale

[Anonymous]

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

[Anonymous · Accepted 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

[Anonymous]

Hi Greg!

thank you for trying to assist with this. Yes. The first "Column" is Assignments made to a team or team member. the second "Column" is the reference to the Team memebrs and what we want to have returned as a value in anew column that would be generated.

Does that answer your question?

Thank you,

Nick Patel

[v-jiascu-msft]

Hi Nick,

I have a few questions.

1. How can a relationship be created in your sample?

2. Are the Answers what you want?

3. If the Q2 is true, how can we get them? For example, how can we get the second value (D Smathers)?

Best Regards,

Dale

[Anonymous]

Hi Dale,

Relationships are and  can be built within Power BI.

The Answers are what I want returned to me as an answer from the lookup/search.

I have not been successful in grabbing this information correctly. That is what this string is for.

Thank you,

Nick Patel