cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mbriveroaks Frequent Visitor
Frequent Visitor

Wildcard character conditioning

Hello community,

 

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. 

 

Source alignment is Source sub-type&Source details and have the same calculated column in other files. 

 

The challenge is to assign the source type as Referral - Employee if Source alignment is "Referral - EmployeeJohn Smith" or any other name.

 

Appreciate any help.Wildcard.jpg

2 REPLIES 2
Stachu Super Contributor
Super Contributor

Re: Wildcard character conditioning

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 option
https://docs.microsoft.com/en-us/powerquery-m/text-start

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

mbriveroaks Frequent Visitor
Frequent Visitor

Re: Wildcard character conditioning

Hi Stachu,

 

Source sub-type have multiple items that keeps changing. * may have multiple changing names.

 

Looking into text start and have to learn DAX & M.

 

many thanks,

Manan

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 45 members 936 guests
Please welcome our newest community members: