Forum Discussion
Address find number
Hi, I have an 'address 1' column with values as follows: 1 Main Street 100 Main Road Avenue Boulevard I want to be able to flag the addresses which don't start with a number, so 'Avenu...
Hi Andybr ,
You can create a Calculated Column.
Assuming that the address in Text DataType
Column = IF(LEFT('Table'[Name],1) IN {"1","2","3","4","5","6","7","8","9","0"},"starts with Number","does not start with number")
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)