Text.Upper: Text.Upper([Name]) : Convert text to uppercase in Power Query

Text.Lower: Text.Lower([Name]) : Lowercase

Text.Trim: Text.Trim([Column]) : Remove spaces

Text.Length: Text.Length([Name]) : Length of string

Text.Replace: Text.Replace([Desc],"old","new") : Replace substring

Number.Round: Number.Round([Price],2) : Round numeric to decimals

Number.Abs: Number.Abs([Delta]) : Absolute number

Date.From: Date.From(DateTime.LocalNow()) : Convert DateTime to Date

DateTime.LocalNow: DateTime.LocalNow() : Current timestamp in PQ

Csv.Document: Csv.Document(File.Contents(path)) : Parse CSV file