Filter rows starting with a certain number (DAX)

[Anonymous]

I have an Account numbers column in a table and I would like to extract the account numbers that start with '6' or '7'. How can I do this using DAX?. 

[Arul · Accepted solution]

@Anonymous ,

try this in calculated column,

Extract Column = 
IF( LEFT(AC[Account NO]) = "6" || LEFT(AC[Account NO]) = "7",AC[Account NO],BLANK())

Thanks,

Arul