Microsoft Power Query M

In this exercise, we will learn about some points to note about the Power Query M language.

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

In this exercise, we will learn about the Create Custom M Function in Power Query.

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

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

In this exercise, we will learn about the "each" keyword 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.AlternateRows 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 Table.RemoveFirstN function of Power Query.

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

In this exercise, we will learn about the Table.DemoteHeaders function 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.Max 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.PadStart function in Power Query.

In this exercise, we will learn about the Text.PadEnd 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.Lower 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.Range function in Power Query.

In this exercise, we will learn about the Text.Select 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.Middle function in Power Query.

In this exercise, we will learn about the Text.PositionOf 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 learn about the Text.TrimEnd function in Power Query.

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

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

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

In this exercise, we will about the Record.ReorderFields 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.HasFields 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.Combine function in Power Query.

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

In this exercise, we will about the Record.AddField 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.IsEmpty 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.MatchesAny function in Power Query.

In this exercise, we will about the List.IsDistinct 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.MatchesAll function in Power Query.

In this exercise, we will about the List.Distinct 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.RemoveRange function in Power Query.

In this exercise, we will about the List.InsertRange 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.Range function in Power Query.

In this exercise, we will about the List.Single 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.Skip function in Power Query.

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

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

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

In this exercise, we will about the Logical.ToText function in Power Query.

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

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

In this exercise, we will about the List.RemoveNulls 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.Split 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.ContainsAny function in Power Query.

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

In this exercise, we will about the List.ReplaceRange 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 List.RemoveMatchingItems 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.ContainsAny function in Power Query.

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

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

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

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

In this exercise, we will learn about the List.NonNullCount function of Power Query.

In this exercise, we will learn about the List.Random function of Power Query.

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

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

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

In this exercise, we will learn about the List.Max 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.FromRows 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.Contains 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.Min function in Power Query.

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

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

In this exercise, we will learn about the Table.IsEmpty 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 Table.MaxN 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.Sum 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.Year 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 Table.TransformColumnTypes function of 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.AddWeeks function in Power Query.

In this exercise, we will learn about the Date.AddDays 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 Table.AddRankColumn 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.FillUp function of Power Query.

In this exercise, we will learn about the Table.FillDown 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 Number.RoundUp function of Power Query.

In this exercise, we will learn about the Number.RoundDown function of Power Query.

In this exercise, we will learn about the Number.Mod function of Power Query.

In this exercise, we will learn about the Number.IsOdd function of Power Query.

In this exercise, we will learn about the Number.IsEven function of Power Query.