Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter rows starting with a certain number (DAX)

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?. 

 

Need Help
  • Arul's avatar
    Arul
    4 years ago

    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

1 Reply

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User
    4 years ago

    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