Forum Discussion
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 ...
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" )
CoreyP
Solution Sage
Solution SageTry 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" )