There's more...

• The most common text functions include Text.Length(), Text.Start(), Text.End(), and Text.Range(). These provide equivalent functionality to the LEN, LEFT, RIGHT, and MID functions in SQL, respectively.
• Text functions start at a 0 base; the second character of the string is 1.
• The Table.Unpivot() and Table.UnpivotOtherColumns() functions are commonly used to transpose data structures in a report layout with financial periods across the columns.