Microsoft Power Query M

In this exercise, we will learn about the Comments in Power Query M.

In this exercise, we will learn about the Lists in Power Query M.

In this exercise, we will learn about the Table.RemoveLastN function in Power Query.

In this exercise, we will learn about the Table.AddColumn function in Power Query.

In this exercise, we will learn about the Table.Column function in Power Query.

In this exercise, we will learn about the Table.ColumnCount function in Power Query.

In this exercise, we will learn about the Table.Combine function in Power Query.

In this exercise, we will learn about the Table.DuplicateColumn function in Power Query.

In this exercise, we will learn about the Table.FirstN function in Power Query.

In this exercise, we will learn about the Table.First function in Power Query.

In this exercise, we will learn about the Table.FirstValue function in Power Query.

In this exercise, we will learn about the Table.Last function in Power Query.

In this exercise, we will learn about the Table.LastN function in Power Query.

In this exercise, we will learn about the "each" keyword in Power Query.

In this exercise, we will learn about the Table.RenameColumns function in Power Query.

In this exercise, we will learn about the Table.PrefixColumns function in Power Query.

In this exercise, we will learn about the Table.RemoveColumns function in Power Query.

In this exercise, we will learn about the Table.ColumnNames function in Power Query.

In this exercise, we will learn about the Table.RowCount function in Power Query.

In this exercise, we will learn about the Table.SelectColumns function in Power Query.

In this exercise, we will learn about the Table.Skip function in Power Query.

In this exercise, we will learn about the Table.Split function in Power Query.

In this exercise, we will learn about the Table.SplitAt function in Power Query.

In this exercise, we will learn about the Table.SelectRows function in Power Query.

In this exercise, we will learn about the Table.SingleRow function in Power Query.

In this exercise, we will learn about the Table.ReverseRows function in Power Query.

In this exercise, we will learn about the Table.Repeat function in Power Query.

In this exercise, we will learn about the Text.Start function in Power Query.

In this exercise, we will learn about the Text.Combine function in Power Query.

In this exercise, we will learn about the Text.Upper function in Power Query.

In this exercise, we will learn about the Text.Lower function in Power Query.

In this exercise, we will learn about the Text.Proper function in Power Query.

In this exercise, we will learn about the Text.ToList function in Power Query.

In this exercise, we will learn about the Text.Replace function in Power Query.

In this exercise, we will learn about the Text.Contains function in Power Query.

In this exercise, we will learn about the Text.EndsWith function in Power Query.

In this exercise, we will learn about the Text.Length function in Power Query.

In this exercise, we will learn about the Text.Remove function in Power Query.

In this exercise, we will learn about the Text.Insert function in Power Query.

In this exercise, we will learn about the Text.End function in Power Query.

In this exercise, we will learn about the Text.At function in Power Query.

In this exercise, we will learn about the Text.Reverse function in Power Query.

In this exercise, we will learn about the Text.Repeat function in Power Query.

In this exercise, we will learn about the Text.Trim function in Power Query.

In this exercise, we will learn about the Text.TrimStart function in Power Query.

In this exercise, we will about the Record.ToTable function in Power Query.

In this exercise, we will about the Record.ToList function in Power Query.

In this exercise, we will about the Record.FromList function in Power Query.

In this exercise, we will about the Record.FieldNames function in Power Query.

In this exercise, we will learn about the Record.FieldValues function in Power Query.

In this exercise, we will about the Record.FieldOrDefault function in Power Query.

In this exercise, we will about the Record.RenameFields function in Power Query.

In this exercise, we will about the Record.RemoveFields function in Power Query.

In this exercise, we will about the Record.FieldCount function in Power Query.

In this exercise, we will about the Record.Field function in Power Query.

In this exercise, we will about the Record.SelectFields function in Power Query.

In this exercise, we will about the List.Count function in Power Query.

In this exercise, we will about the List.LastN function in Power Query.

In this exercise, we will about the List.First function in Power Query.

In this exercise, we will about the List.FindText function in Power Query.

In this exercise, we will about the List.FirstN function in Power Query.

In this exercise, we will about the List.RemoveFirstN function in Power Query.

In this exercise, we will about the List.RemoveLastN function in Power Query.

In this exercise, we will about the List.Last function in Power Query.

In this exercise, we will about the List.Select function in Power Query.

In this exercise, we will about the List.Repeat function in Power Query.

In this exercise, we will about the List.ReplaceValue function in Power Query.

In this exercise, we will about the List.Reverse function in Power Query.

In this exercise, we will about the List.RemoveItems function in Power Query.

In this exercise, we will learn about the Table.IsDistinct function in Power Query.

In this exercise, we will learn about the Table.ReplaceValue function in Power Query.

In this exercise, we will learn about the Table.Transpose function in Power Query.

In this exercise, we will learn about the Table.FromRecords function in Power Query.

In this exercise, we will learn about the Table.FromValue function in Power Query.

In this exercise, we will learn about the Table.AddIndexColumn function in Power Query.

In this exercise, we will learn about the Table.Distinct function in Power Query.

In this exercise, we will learn about the Table.ExpandRecordColumn function in Power Query.

In this exercise, we will learn about the Table.InsertRows function in Power Query.

In this exercise, we will learn about the Table.TransformColumns function in Power Query.

In this exercise, we will learn about the Table.ToRows function in Power Query.

In this exercise, we will learn about the Table.TransformRows function in Power Query.

In this exercise, we will learn about the Table.Sort function in Power Query.

In this exercise, we will learn about the Table.TransformColumnNames function in Power Query.

In this exercise, we will learn about the Table.ToColumns function in Power Query.

In this exercise, we will learn about the Table.ToRecords function in Power Query.

In this exercise, we will learn about the Table.ToList function in Power Query.

In this exercise, we will learn about the Date.EndOfWeek function in Power Query.

In this exercise, we will learn about the List.Sort function in Power Query.

In this exercise, we will learn about the Date.EndOfYear function in Power Query.

In this exercise, we will learn about the Date.EndOfMonth function in Power Query.

In this exercise, we will learn about the Date.DaysInMonth function in Power Query.

In this exercise, we will learn about the Date.DayOfYear function in Power Query.

In this exercise, we will learn about the Date.StartOfMonth function in Power Query.

In this exercise, we will learn about the Date.AddYears function in Power Query.

In this exercise, we will learn about the Table.RemoveRows function in Power Query.

In this exercise, we will learn about the Date.DayOfWeekName function of Power Query.

In this exercise, we will learn about the Date.DayOfWeek function in Power Query.

In this exercise, we will learn about the Date.EndOfQuarter function in Power Query.

In this exercise, we will learn about the Date.Day function in Power Query.

In this exercise, we will learn about the Date.AddMonths function in Power Query.

In this exercise, we will learn about the Date.IsInNextYear function in Power Query.

In this exercise, we will learn about the Date.IsInPreviousWeek function in Power Query.

In this exercise, we will learn about the Date.IsInPreviousYear function in Power Query.

In this exercise, we will learn about the Date.IsInPreviousMonth function in Power Query.

In this exercise, we will learn about the Date.IsLeapYear function in Power Query.

In this exercise, we will learn about the Date.MonthName function in Power Query.

In this exercise, we will learn about the Date.QuarterOfYear function in Power Query.

In this exercise, we will learn about the Date.IsInPreviousDay function in Power Query.

In this exercise, we will learn about the Date.IsInNextMonth function in Power Query.

In this exercise, we will learn about the Date.IsInPreviousQuarter function in Power Query.

In this exercise, we will learn about the Date.Month function in Power Query.

In this exercise, we will learn about the Date.StartOfYear function in Power Query.

In this exercise, we will learn about the Date.IsInCurrentYear function in Power Query.

In this exercise, we will learn about the Date.IsInCurrentMonth function in Power Query.

In this exercise, we will learn about the Date.ToRecord function in Power Query.

In this exercise, we will learn about the Date.WeekOfYear function in Power Query.

In this exercise, we will learn about the #date function in Power Query.

In this exercise, we will learn about the Date.Year function in Power Query.

In this exercise, we will learn about the IF function in Power Query.

In this exercise, we will learn about the Table.FromPartitions function in Power Query.

In this exercise, we will learn about the Table.MatchesAnyRows function in Power Query.

In this exercise, we will learn about the Table.RemoveMatchingRows function in Power Query.

In this exercise, we will learn about the Table.RemoveFirstN function of Power Query.

In this exercise, we will learn about the Table.HasColumns function of Power Query.

In this exercise, we will learn about the Table.FromColumns function of Power Query.

In this exercise, we will learn about the Table.TransformColumnTypes function of Power Query.