Date.IsInNextMonth Table.Unpivot Date.ToText In this case T-Shirt or Sweater. PS - I've taken to writing my PowerQuery stuff in Visual Studio Code and it is a GREAT way to work! Salesforce.Data The starting point is a table with workitems, basically tasks from a todo list. Note: Text.Proper List.Single Youre not the first and definitely not the last to experience syntax errors in Power Query . DateTime.FromText Why Date.IsInNextNQuarters List.Product BinaryFormat.UnsignedInteger16 In Condition 4, I want to check if the current item starts with X or Y but it is not behaving correctly. Power Query Change Text if it Contains a certain word or group of words Ask Question Asked 5 years, 3 months ago Modified 5 years, 3 months ago Viewed 12k times 0 I have a query that pulls in the banking activity each month and compares it to the prior months' activity using a pivot table. on: function(evt, cb) { } Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. DateTime.Time Expression.Evaluate Tried following the above steps and applying the logic to a stock run out date but every entry returns error? While slightly more complex, its closely related to the conditional logic in IF functions. Date.IsInCurrentDay Table.RemoveColumns Text.StartsWith - Power Query How Any help suggestions is greatly appreciated. Excel.Workbook Text.Insert. SapBusinessWarehouse.Cubes Appends a specified value to the start of a given text field until it is at least a specified length. For example, you can check if a date falls within a specific range: Or, you could categorize dates by day of the week: In this section, well explore more advanced techniques for working with IF statements in Power Query. Int64.From