/PowerQuery-Functions

A collection of functions written in Power Query (M)

MIT LicenseMIT

PowerQuery Functions

A collection of functions written in Power Query (M)

What you'll find:

Table Manipulation

Function Description
Table.CombineMultipleColumns For double headers. Combine columns by any setSize in one step.
Table.DistinctMerge Combines two tables based on duplicate keys keeping only one item per row.
Table.GenerateColumns To add multiple columns based on similar functions.

Have you thought about just unpivoting and adding one column afterwards?
Table.InferColumnTypes Infer column types.

Supply a tableName to get back code as text.
Table.ReplaceValuesFromTable Optimised mass replace values in columns.
Table.ToTableView Automatically apply a Table.View function based on Table.Schema.

Time Intelligence

Function Description
DateTime.Diff DateTime Diff using Excluded Dates list and Start Time / End Time.
Date.Diff Date Diff using Excluded Dates list.
Duration.To All Duration.Totalxxxx functions in one.

Model

Function Description
PowerBI.Current Connects to current PBI model. Requires userName.

Needs exactly one Power BI Desktop instance running.

Does not work in Power BI Service.

Misc

Function Description
Get.TableView Get formatted Table.View function based on Table.Schema or by infering types.
Type.TableType Get text of non abstract table type.
Type.ToText Get text representation of any type.