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.