I want the cell to be formatted if the cell contains any of the following words: blue, orange, red, green, and white. Pivot Text Values in Power Query - Explained - Gorilla BI Measure = IF (OR (CONTAINS ('Data','Data' [Category],"GP"),CONTAINS ('Data','Data' [Category],"Other Value")), DIVIDE ( [Current Year Actual], [Current Year Budget])) Hope this helps Thanks, George View solution in original post … power query if text contains multiple values Lists in Power Query M / List Functions (200+ Examples) I can do it manually from "create conditional column" in PowerBi but it will take me a million years. power query if text contains multiple values It will do the merge. Add a Custom Column to the table by clicking Add Column -> Custom Column. An optional equation criteria value, equationCriteria, can be … First way with minimum one - query the table and add Index, nothing more - reference this one, … Here, the list to search is the text in each row of TextCol, and the words we're looking for are in WordList. You can choose from three methods to filter the values in your column: Sort and filter … Power Query - If Statements for Conditional Logic - Excel Off The … The equivalent of the IN function in Power Query uses List.Contains: The function evaluates whether the list contains the value in the column Package. If the value appears, the expression returns true. This example only uses two values in its list.