Forum Discussion

moatazbelah's avatar
moatazbelah
Regular Visitor
4 years ago
Solved

Comparing two columns with addresses

I'm trying to compare two columns. Each column has the address. I'm trying to create another column that says True or False if the two columns match or not. The issue that I'm having is if the addres...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    moatazbelah 
    You can add a custom column as follows

    = Text.Contains([address 1],[address 2],Comparer.OrdinalIgnoreCase) or Text.Contains([address 2],[address 1],Comparer.OrdinalIgnoreCase)

     

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, moatazbelah 

 

You can try to solve the problem with Dax.

Column = 
IF(LEFT([address 1],5)=LEFT([address 2],5),"True","False")

LEFT: https://docs.microsoft.com/dax/left-function-dax 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.