Forum Discussion
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...
Stachu
Community Champion
Community Championcan'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
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