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

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