datetime
Add support for DateTime as first-order data column, not just as label. Currently DateTime can only be displayed with Count Of.
function editor
Enable any query to be turned into a function by adding a right-click "introduce parameter" command
Query Editing: Add reverse of ToTable () command to ribbon, for turning a table into a list
Currently, it's trivial to turn a list into a table, but not the other way around. Many transformations are more natural on a list than a table.
Apply consistent indentation for multi-line formulas for viewing in advanced editor
In the Power Query Editor, it is possible to enter a multi-line formula in the formula bar. For example: = () => let Source = SampleIndexedTimeline, fxFormPath = (_) => if _[parentIndex] <> null then Number.ToText(_[parentIndex]) & "/" & _[idPath] else _[idPath] Wh...
Editing a formula in the formula bar should preserve newlines, not replace with #(lf)
Using the Power Query formula bar to edit something like this:
= (_TimelineWithParent as any) => let
Initial = _TimelineWithParent,
#"Add initial pidx" = Table.DuplicateColumn(Initial, "parentIndex", "pidx"),
File.Contents should support extracting a part of a file
When developing queries with PowerQuery, it can be useful to operate on a small subset of the data in order to speed testing. If the start of a query is File.Contents () , there is no way to limit the amount of data that is read from the file, so the whole file gets pulled into memory. This can...