String Matching

Anonymous · ‎05-24-2023

Hello PBI Users,

I have a situation where i need to match / compare two columns

values would be -

Col 1

bic-payment-error-attempt-5

Col 2

bic/payment-error-attempt-5-en-US-activity-DECR-241

I need a YES result while comparing these things

Can you help what DAX can i use here ??

Greg_Deckler · ‎05-24-2023

@Anonymous I created a fuzzy matching DAX measure once...

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources