Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

Power Query Cheat Sheet (DRAFT) by

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Conver­sions

From
ToBinary /FromB­inary
ToList
FromNumber / ToNumber
Value.F­ro­mText
Text.N­ewGuid
Value.*

Number

IsNan
Number.Is­NaN­(0/0) = true
IsEven / IsOdd

Rounding

Round, RoundUp, RoundDown, RoundTowardZero, RoundAwayFromZero

Operations

Sign, Abs, Mod, Power, Sqrt, Exp, Ln, Log, Factorial, Intege­rDivide
Standard math functions.
Combin­ations, Permut­ations

String Transf­orm­ation

Clean
Combine
Upper / Lower / Proper
PadStart/ PadEnd
Trim / TrimStart/ TrimEnd
Repeat
Split / SplitAny

String Manipu­lation

At
Range
Start
End

String Manipu­lation

Insert
Remove
Remove­Range
Replace

String Search

Contains
PositionOf / Positi­onOfAny
StartsWith / EndsWith
 

Date

AddPe­riod, IsInPr­evi­uos­Period, IsInCu­rre­nt­Period,
IsInNe­xt­Period, IsInYe­arT­oDate, IsLeapYear, DayOfWeek / DayOfYear,
StartO­fP­eriod, EndOf­Period
Period can be Day, Week, Month, Quarter, or Year (for AddPeriod, Period is plural i.e. Days.)

Time

StartO­fHour, EndOfHour, Hour, Minute, Second

DateTime

 

DateTi­meZone

 

Duration

 
 

Record

 

List

 

Table

 
 

Accessing Data

 

Uri

 

Lines

 

Expres­sio­n.E­valute

 
Expres­sio­ns.C­on­tant, Expres­sio­n.I­den­tifier

MetaFu­nctions

Function
Error
Combiner
Comparer
Splitter
Replacer
Type

CUbe

 

Binary Data