Forum Discussion

Anonymous

Not applicable

5 years ago

like operator as join condition between tables

hi, i want to join (inner) between table A to B based on LIKE opeartor logic: ON A.Column LIKE '%' + B.Column+ '%' example: XXXXXX8074396XXXXXXX LIKE '%' + 8074396+ '%' ----> there is a much ...

Icon for Community Champion rank

Community Champion

5 years ago

where are you trying to do this join exactly? Are you using power query / dax?

please provide more information about what you are trying to do.

Anonymous

Not applicable

5 years ago

thanks! Table A and B are views in SQL im using as a source in Power BI

i don't familiar with DAX which can help me

i tried to merage between the table using fuzzy match via power query