Disable Step (Comment Out) within GUI
It would be very helpful if there was an option to right click on a step from within the Power Query GUI and "disable" it (which behind the scenes would really just comment out that line and change the next line's table references automatically). The reason it is helpful is if I am wanting to te...
Include MissingField Argument with Table.TransformColumnTypes Function for Power Query
From what I can see (and it's not listed in the M function reference) the built in Table.TransformColumnTypes doesn't accept the MissingField argument like most of the other Table functions. This is extremely troublesome because if you are processing a dynamic data source, columns could come and ...
Conditional Columns with Multiple Criteria in Power Query
The Conditional Column button is very handy however often it is necessary to qualify a condition using two different criteria (ex. if [Fruit Type] = "Apples" and [Amt Sold] > 5 then "Top Seller"), it would be very handy to have this as an added feature. Going one step further, often there are mu...