Forum Discussion

Andybr's avatar
Andybr
Frequent Visitor
6 years ago

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

 

Thanks,

 

Andy

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Andybr 

    create a column

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

    and filter by Column = True