Address find number

[Andybr]

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 'Avenue & Boulevard' above - can this be done using DAX?

Thanks,

Andy

[harshnathani]

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)

[az38]

Hi @Andybr 

create a column

Column = IF(ISERROR(VALUE(LEFT([Address 1],1))), TRUE(), FALSE())

and filter by Column = True

[Andybr]

Appreciated - thanks @az38