Filter from within Power BI

[vandam2]

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?

[Anonymous]

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. 

[CoreyP · Accepted solution]

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" )