Forum Discussion

vandam2's avatar
vandam2
Frequent Visitor
2 years ago
Solved

Filter from within Power BI

i have a list of inventory (computer names)

i would like the option to filter the computers starting with M and has total of 7 characters (eg. M234567)

 

is there a way i can do this from advance filtering? or does it have to be in powerquery?

 

Tips and Tricks
  • CoreyP's avatar
    CoreyP
    2 years ago

    Try creating a calculated column using LEFT and LEN. Something like..

    Filter Flag = IF( AND( LEFT( 'Table'[ComputerName] , 1 ) = "M" , LEN( 'Table'[ComputerName] ) = 7 ) , "true" , "false" )

2 Replies

  • CoreyP's avatar
    CoreyP
    Solution Sage
    2 years ago

    Try creating a calculated column using LEFT and LEN. Something like..

    Filter Flag = IF( AND( LEFT( 'Table'[ComputerName] , 1 ) = "M" , LEN( 'Table'[ComputerName] ) = 7 ) , "true" , "false" )

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi vandam2 ,

     

    Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.