Forum Discussion
Filtering on Text
MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)
Thank you for your response Greg_Deckler
What did you mean by "uset the Text filters fly-out"? Sorry I'm new to DAX. Thank you before-hand.
Thank you Greg_Deckler
I am actually trying to create new table with DAX expression based on data in another larger table using Filter function based on multiple boolean expressions
MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)