Wildcard character conditioning

Question

Hello community,&nbsp;New to powerbi, stuck in a situation. Have this lookup table with 1:many relationship. The source table may have Referral - Employee/ hiring manager/ other in source sub-type and source details may have any name.&nbsp;&nbsp;Source alignment is Source sub-type&amp;Source details and have the same calculated column in other files.&nbsp;&nbsp;The challenge is to assign the source type as Referral - Employee if Source alignment is "Referral - EmployeeJohn Smith" or any other name.&nbsp;Appreciate any help.

stachu · Answer

can't you just base Source-Type based on the Source-SubType?in the provided example they seem identical
also, are you looking for DAX or M solution?if you can use the SubType the problem becomes much simpler, if you need to work with Source Alignment then Text.Start seems like a reasonable optionhttps://docs.microsoft.com/en-us/powerquery-m/text-start

anonymous · Answer

Hi Stachu,&nbsp;Source sub-type have multiple items that keeps changing. * may have multiple changing names.&nbsp;Looking into text start and have to learn DAX &amp; M.&nbsp;many thanks,Manan

Forum Discussion

Wildcard character conditioning

2 Replies

Related content

Documentation regarding Wildcard Characters

use wildcard characters in query editor

Wildcard characters in filter expression

Use Wildcard Operator

Using wildcard characters in a SWITCH function