Microsoft Power Query M
Learn how to write powerful data transformation scripts using the Power Query M language. Master M functions, queries, parameters, and advanced data shaping techniques to build efficient data pipelines in Power BI and Excel using the Power Query Editor.
⚙️ Basics of Power Query
Basic Points in Power Query M language
Learn the important concepts and rules used in Power Query M language.
Comments in Power Query
Understand how to write comments in Power Query M code.
Create Custom M Function in Power Query
Learn how to create reusable custom functions using M language.
Each keyword in Power Query
Understand how the each keyword simplifies expressions.
Variables in Power Query
Learn how variables are defined and used in Power Query M scripts.
IF Function in Power Query
Apply conditional logic using the IF function in Power Query.
Coalesce Operator (??) in Power Query
Handle null values efficiently using the Coalesce operator.
🔤 Text Functions in Power Query
Text.Start Function in Power Query
Extract characters from the beginning of a text value.
Text.Combine Function in Power Query
Merge multiple text values into a single string.
Text.Upper Function in Power Query
Convert text values into uppercase characters.
Text.PadStart Function in Power Query
Add characters at the beginning of text values.
Text.PadEnd Function in Power Query
Add characters at the end of text values.
Text.Proper Function in Power Query
Convert text into proper case format.
Text.ToList Function in Power Query
Convert text characters into a list of values.
Text.Lower Function in Power Query
Convert text values into lowercase characters.
Text.Replace Function in Power Query
Replace specific text values inside a string.
Text.Range Function in Power Query
Extract a portion of text based on starting position and length.
Text.Select Function in Power Query
Select specific characters from a text value.
Text.Contains Function in Power Query
Check whether a text value contains a specific substring.
Text.EndsWith Function in Power Query
Determine whether a text value ends with a specific string.
Text.Middle Function in Power Query
Extract characters from the middle of a text value.
Text.PositionOf Function in Power Query
Find the position of a substring within a text value.
Text.Length Function in Power Query
Return the total number of characters in a text value.
Text.Remove Function in Power Query
Remove specified characters from text values.
Text.Insert Function in Power Query
Insert characters into a text value at a specific position.
Text.End Function in Power Query
Return characters from the end of a text value.
Text.At Function in Power Query
Return a character at a specific position within text.
Text.Reverse Function in Power Query
Reverse the order of characters in a text value.
Text.AfterDelimiter Function in Power Query
Return text appearing after a specified delimiter.
Text.BeforeDelimiter Function in Power Query
Return text appearing before a delimiter.
Text.Repeat Function in Power Query
Repeat a text value multiple times.
Text.Trim Function in Power Query
Remove spaces from the beginning and end of text values.
Text.TrimStart Function in Power Query
Remove spaces from the start of text values.
Text.TrimEnd Function in Power Query
Remove spaces from the end of text values.
Text.NewGuid Function in Power Query
Generate a globally unique identifier (GUID) as a text value.
Text.SplitAny Function in Power Query
Split text using multiple delimiter characters.
Text.Split Function in Power Query
Split text into a list using a specified delimiter.
Text.RemoveRange Function in Power Query
Remove a range of characters from a text value.
Text.PositionOfAny Function in Power Query
Find the position of any character from a list in a text value.
Text.StartsWith Function in Power Query
Check whether a text value starts with a specific string.
📋 List Functions in Power Query
Lists in Power Query
Learn how lists work in Power Query and how to create and manipulate them.
List.Count Function in Power Query
Count the total number of elements inside a list.
List.IsEmpty Function in Power Query
Check whether a list contains any elements.
List.LastN Function in Power Query
Return the last N elements from a list.
List.First Function in Power Query
Retrieve the first value from a list.
List.FindText Function in Power Query
Search a list and return elements containing specific text.
List.FirstN Function in Power Query
Return the first N items from a list.
List.MatchesAny Function in Power Query
Check whether any list element satisfies a condition.
List.IsDistinct Function in Power Query
Determine whether all values in a list are unique.
List.RemoveFirstN Function in Power Query
Remove a specified number of elements from the beginning of a list.
List.MatchesAll Function in Power Query
Check whether all elements satisfy a specific condition.
List.Distinct Function in Power Query
Return only unique values from a list.
List.RemoveLastN Function in Power Query
Remove elements from the end of a list.
List.Last Function in Power Query
Retrieve the last element from a list.
List.RemoveRange Function in Power Query
Remove a specified range of elements from a list.
List.InsertRange Function in Power Query
Insert a set of elements into a list at a specific position.
List.Select Function in Power Query
Filter list elements based on a condition.
List.Range Function in Power Query
Return a subset of a list using a starting position and length.
List.Single Function in Power Query
Return the single element from a list that contains exactly one item.
List.Repeat Function in Power Query
Create a list by repeating values multiple times.
List.Skip Function in Power Query
Skip a specified number of elements from the beginning of a list.
List.Alternate Function in Power Query
Select alternating elements from a list.
List.Positions Function in Power Query
Return the index positions of elements in a list.
List.PositionOf Function in Power Query
Find the index of a value within a list.
List.PositionOfAny Function in Power Query
Find the position of any matching value from another list.
List.Zip Function in Power Query
Combine multiple lists into a single list of paired values.
List.RemoveNulls Function in Power Query
Remove all null values from a list.
List.ReplaceValue Function in Power Query
Replace specific values within a list.
List.Split Function in Power Query
Split a list into smaller lists based on a specified size.
List.Reverse Function in Power Query
Reverse the order of elements in a list.
List.ContainsAny Function in Power Query
Check if a list contains any values from another list.
List.Difference Function in Power Query
Return elements that exist in one list but not in another.
List.ReplaceRange Function in Power Query
Replace a range of elements inside a list.
List.RemoveItems Function in Power Query
Remove specific values from a list.
List.RemoveMatchingItems Function in Power Query
Remove elements that match values from another list.
List.Union Function in Power Query
Combine multiple lists into a single list of unique values.
List.Contains Function in Power Query
Check whether a list contains a specific value.
List.Combine Function in Power Query
Merge multiple lists into a single list.
List.AnyTrue Function in Power Query
Check whether any value in a logical list is TRUE.
List.Transform Function in Power Query
Apply a transformation function to each element of a list.
List.TransformMany Function in Power Query
Transform list elements and expand them into multiple values.
List.NonNullCount Function of Power Query
Count the number of non-null values in a list.
List.Random Function of Power Query
Generate a list containing random numbers.
List.Mode Function in Power Query
Return the most frequently occurring value in a list.
List.Modes Function in Power Query
Return all most frequently occurring values from a list.
List.Numbers Function in Power Query
Create a list of numbers starting from a specific value.
List.Average Function of Power Query
Calculate the average of values contained in a list.
List.Max Function in Power Query
Return the maximum value from a list.
List.Sum Function in Power Query
Calculate the sum of numeric values in a list.
List.Sort Function in Power Query
Sort list elements in ascending or descending order.
List.MaxN Function in Power Query
Return the top N maximum values from a list.
List.Min Function in Power Query
Return the minimum value from a list.
List.MinN Function in Power Query
Return the smallest N values from a list.
List.Accumulate Function of Power Query
Iteratively accumulate values in a list using a custom function.
List.Intersect Function of Power Query
Return values that exist in multiple lists.
List.ContainsAll Function of Power Query
Check whether all specified values exist in a list.
List.AllTrue Function of Power Query
Return TRUE if all values in a logical list are TRUE.
List.Dates Function of Power Query
Create a list containing sequential date values.
List.Product Function of Power Query
Multiply all numeric values contained in a list.
List.SingleOrDefault Function of Power Query
Return a single value from a list or a default value if none exists.
List.ReplaceMatchingItems Function of Power Query
Replace items in a list that match specified values.
🧩 Record Functions in Power Query
Records in Power Query
Learn how records work in Power Query M and how they store field-value pairs.
Record.ReorderFields Function in Power Query
Rearrange the order of fields inside a record structure.
Record.ToTable Function in Power Query
Convert a record into a table format for easier data manipulation.
Record.ToList Function in Power Query
Transform record values into a list structure.
Record.FromList Function in Power Query
Create a record using a list of values and corresponding field names.
Record.FieldNames Function in Power Query
Retrieve all field names from a record structure.
Record.FieldValues Function in Power Query
Extract all values from a record as a list.
Record.FieldOrDefault Function in Power Query
Return a field value or a default value if the field does not exist.
Record.RenameFields Function in Power Query
Rename fields inside a record structure.
Record.RemoveFields Function in Power Query
Remove specific fields from a record.
Record.HasFields Function in Power Query
Check whether a record contains specific fields.
Record.FieldCount Function in Power Query
Count the number of fields in a record.
Record.Field Function in Power Query
Retrieve the value of a specific field from a record.
Record.Combine Function in Power Query
Merge multiple records into a single record.
Record.SelectFields Function in Power Query
Select specific fields from a record structure.
Record.AddField Function in Power Query
Add a new field and value to an existing record.
Record.FromTable Function in Power Query
Convert a table into a record structure.
📊 Table Functions in Power Query
#table Function in Power Query
In this exercise, we will learn about the #table function in Power Query.
Table.AddColumn Function in Power Query
In this exercise, we will learn about the Table.AddColumn function in Power Query.
Table.AlternateRows Function in Power Query
In this exercise, we will learn about the Table.AlternateRows function in Power Query.
Table.Column Function in Power Query
In this exercise, we will learn about the Table.Column function in Power Query.
Table.ColumnCount Function in Power Query
In this exercise, we will learn about the Table.ColumnCount function in Power Query.
Table.Combine Function in Power Query
In this exercise, we will learn about the Table.Combine function in Power Query.
Table.DuplicateColumn Function in Power Query
In this exercise, we will learn about the Table.DuplicateColumn function in Power Query.
Table.FirstN Function in Power Query
In this exercise, we will learn about the Table.FirstN function in Power Query.
Table.First Function in Power Query
In this exercise, we will learn about the Table.First function in Power Query.
Table.FirstValue Function in Power Query
In this exercise, we will learn about the Table.FirstValue function in Power Query.
Table.Last Function in Power Query
In this exercise, we will learn about the Table.Last function in Power Query.
Table.LastN Function in Power Query
In this exercise, we will learn about the Table.LastN function in Power Query.
Table.RemoveFirstN Function of Power Query
In this exercise, we will learn about the Table.RemoveFirstN function of Power Query.
Table.RemoveLastN Function in Power Query
In this exercise, we will learn about the Table.RemoveLastN function in Power Query.
Table.DemoteHeaders Function in Power Query
In this exercise, we will learn about the Table.DemoteHeaders function in Power Query.
Table.RenameColumns Function in Power Query
In this exercise, we will learn about the Table.RenameColumns function in Power Query.
Table.Max Function in Power Query
In this exercise, we will learn about the Table.Max function in Power Query.
Table.PrefixColumns Function in Power Query
In this exercise, we will learn about the Table.PrefixColumns function in Power Query.
Table.RemoveColumns Function in Power Query
In this exercise, we will learn about the Table.RemoveColumns function in Power Query.
Table.ReorderColumns Function in Power Query
In this exercise, we will learn about the Table.ReorderColumns function in Power Query.
Table.ColumnNames Function in Power Query
In this exercise, we will learn about the Table.ColumnNames function in Power Query.
Table.ReplaceRows in Power Query
In this exercise, we will learn about the Table.ReplaceRows function in Power Query.
Table.RowCount Function in Power Query
In this exercise, we will learn about the Table.RowCount function in Power Query.
Table.SelectColumns Function in Power Query
In this exercise, we will learn about the Table.SelectColumns function in Power Query.
Table.Skip Function in Power Query
In this exercise, we will learn about the Table.Skip function in Power Query.
Table.Split Function in Power Query
In this exercise, we will learn about the Table.Split function in Power Query.
Table.SplitAt Function in Power Query
In this exercise, we will learn about the Table.SplitAt function in Power Query.
Table.SelectRows Function in Power Query
In this exercise, we will learn about the Table.SelectRows function in Power Query.
Table.SingleRow Function in Power Query
In this exercise, we will learn about the Table.SingleRow function in Power Query.
Table.ReverseRows Function in Power Query
In this exercise, we will learn about the Table.ReverseRows function in Power Query.
Table.Repeat Function in Power Query
In this exercise, we will learn about the Table.Repeat function in Power Query.
Table.IsDistinct Function in Power Query
In this exercise, we will learn about the Table.IsDistinct function in Power Query.
Table.ContainsAny Function in Power Query
In this exercise, we will learn about the Table.ContainsAny function in Power Query.
Table.ExpandTableColumn Function in Power Query
In this exercise, we will learn about the Table.ExpandTableColumn function in Power Query.
Table.ReplaceValue Function in Power Query
In this exercise, we will learn about the Table.ReplaceValue function in Power Query.
Table.Transpose Function in Power Query
In this exercise, we will learn about the Table.Transpose function in Power Query.
Table.FromRecords Function in Power Query
In this exercise, we will learn about the Table.FromRecords function in Power Query.
Table.FromRows Function in Power Query
In this exercise, we will learn about the Table.FromRows function in Power Query.
Table.FromValue Function in Power Query
In this exercise, we will learn about the Table.FromValue function in Power Query.
Table.Contains Function in Power Query
In this exercise, we will learn about the Table.Contains function in Power Query.
Table.CombineColumns Function in Power Query
In this exercise, we will learn about the Table.CombineColumns function in Power Query.
Table.AddIndexColumn Function in Power Query
In this exercise, we will learn about the Table.AddIndexColumn function in Power Query.
Table.ExpandListColumn Function in Power Query
In this exercise, we will learn about the Table.ExpandListColumn function in Power Query.
Table.PromoteHeaders Function in Power Query
In this exercise, we will learn about the Table.PromoteHeaders function in Power Query.
Table.Distinct Function in Power Query
In this exercise, we will learn about the Table.Distinct function in Power Query.
Table.Min Function in Power Query
In this exercise, we will learn about the Table.Min function in Power Query.
Table.MinN Function in Power Query
In this exercise, we will learn about the Table.MinN function in Power Query.
Table.Group Function in Power Query
In this exercise, we will learn about the Table.Group function in Power Query.
Table.IsEmpty Function in Power Query
In this exercise, we will learn about the Table.IsEmpty function in Power Query.
Table.ExpandRecordColumn Function in Power Query
In this exercise, we will learn about the Table.ExpandRecordColumn function in Power Query.
Table.PositionOf Function in Power Query
In this exercise, we will learn about the Table.PositionOf function in Power Query.
Table.PositionOfAny Function in Power Query
In this exercise, we will learn about the Table.PositionOfAny function in Power Query.
Table.InsertRows Function in Power Query
In this exercise, we will learn about the Table.InsertRows function in Power Query.
Table.Schema Function in Power Query
In this exercise, we will learn about the Table.Schema function in Power Query.
Table.TransformColumns Function in Power Query
In this exercise, we will learn about the Table.TransformColumns function in Power Query.
Table.Unpivot Function in Power Query
In this exercise, we will learn about the Table.Unpivot function in Power Query.
Table.UnpivotOtherColumns Function in Power Query
In this exercise, we will learn about the Table.UnpivotOtherColumns function in Power Query.
Table.NestedJoin Function in Power Query
In this exercise, we will learn about the Table.NestedJoin function in Power Query.
Table.ToRows Function in Power Query
In this exercise, we will learn about the Table.ToRows function in Power Query.
Table.TransformRows Function in Power Query
In this exercise, we will learn about the Table.TransformRows function in Power Query.
Table.Sort Function in Power Query
In this exercise, we will learn about the Table.Sort function in Power Query.
Table.TransformColumnNames Function in Power Query
In this exercise, we will learn about the Table.TransformColumnNames function in Power Query.
Table.ToColumns Function in Power Query
In this exercise, we will learn about the Table.ToColumns function in Power Query.
Table.ToRecords Function in Power Query
In this exercise, we will learn about the Table.ToRecords function in Power Query.
Table.SplitColumn Function in Power Query
In this exercise, we will learn about the Table.SplitColumn function in Power Query.
Table.ToList Function in Power Query
In this exercise, we will learn about the Table.ToList function in Power Query.
Table.MaxN Function in Power Query
In this exercise, we will learn about the Table.MaxN function in Power Query.
Table.RemoveRows Function in Power Query
In this exercise, we will learn about the Table.RemoveRows function in Power Query.
Table.TransformColumnTypes Function of Power Query
In this exercise, we will learn about the Table.TransformColumnTypes function of Power Query.
Table.Profile Function in Power Query
In this exercise, we will learn about the Table.Profile function in Power Query.
Table.AddRankColumn Function in Power Query
In this exercise, we will learn about the Table.AddRankColumn function in Power Query.
Table.FromPartitions Function in Power Query
In this exercise, we will learn about the Table.FromPartitions function in Power Query.
Table.MatchesAnyRows Function in Power Query
In this exercise, we will learn about the Table.MatchesAnyRows function in Power Query.
Table.RemoveMatchingRows Function in Power Query
In this exercise, we will learn about the Table.RemoveMatchingRows function in Power Query.
Table.SelectRowsWithErrors Function in Power Query
In this exercise, we will learn about the Table.SelectRowsWithErrors function in Power Query.
Table.FillUp Function of Power Query
In this exercise, we will learn about the Table.FillUp function of Power Query.
Table.FillDown Function of Power Query
In this exercise, we will learn about the Table.FillDown function of Power Query.
Table.HasColumns Function of Power Query
In this exercise, we will learn about the Table.HasColumns function of Power Query.
Table.FromColumns Function of Power Query
In this exercise, we will learn about the Table.FromColumns function of Power Query.
Table.FindText Function of Power Query
In this exercise, we will learn about the Table.FindText function of Power Query.
Table.Pivot Function of Power Query
In this exercise, we will learn about the Table.Pivot function of Power Query.
Table.ReplaceErrorValues Function of Power Query
In this exercise, we will learn about the Table.ReplaceErrorValues function of Power Query.
Table.Partition Function of Power Query
In this exercise, we will learn about the Table.Partition function of Power Query.
Table.RemoveRowsWithErrors Function of Power Query
In this exercise, we will learn about the Table.RemoveRowsWithErrors function of Power Query.
Table.FromList Function of Power Query
In this exercise, we will learn about the Table.FromList function of Power Query.
Table.MatchesAllRows Function of Power Query
In this exercise, we will learn about the Table.MatchesAllRows function of Power Query.
Table.ContainsAll Function of Power Query
In this exercise, we will learn about the Table.ContainsAll function of Power Query.
Table.ReplaceMatchingRows Function of Power Query
In this exercise, we will learn about the Table.ReplaceMatchingRows function of Power Query.
📅 Date Functions in Power Query
#date Function in Power Query
In this exercise, we will learn about the #date function in Power Query.
Date.AddQuarters Function in Power Query
In this exercise, we will learn about the Date.AddQuarters function in Power Query.
Date.EndOfWeek Function in Power Query
In this exercise, we will learn about the Date.EndOfWeek function in Power Query.
Date.EndOfYear Function in Power Query
In this exercise, we will learn about the Date.EndOfYear function in Power Query.
Date.EndOfMonth Function in Power Query
In this exercise, we will learn about the Date.EndOfMonth function in Power Query.
Date.DaysInMonth Function in Power Query
In this exercise, we will learn about the Date.DaysInMonth function in Power Query.
Date.Year Function in Power Query
In this exercise, we will learn about the Date.Year function in Power Query.
Date.DayOfYear Function in Power Query
In this exercise, we will learn about the Date.DayOfYear function in Power Query.
Date.StartOfMonth Function in Power Query
In this exercise, we will learn about the Date.StartOfMonth function in Power Query.
Date.AddYears Function in Power Query
In this exercise, we will learn about the Date.AddYears function in Power Query.
Date.DayOfWeekName Function of Power Query
In this exercise, we will learn about the Date.DayOfWeekName function of Power Query.
Date.DayOfWeek Function in Power Query
In this exercise, we will learn about the Date.DayOfWeek function in Power Query.
Date.EndOfQuarter Function in Power Query
In this exercise, we will learn about the Date.EndOfQuarter function in Power Query.
Date.Day Function in Power Query
In this exercise, we will learn about the Date.Day function in Power Query.
Date.AddMonths Function in Power Query
In this exercise, we will learn about the Date.AddMonths function in Power Query.
Date.AddWeeks Function in Power Query
In this exercise, we will learn about the Date.AddWeeks function in Power Query.
Date.AddDays Function in Power Query
In this exercise, we will learn about the Date.AddDays function in Power Query.
Date.IsInNextYear Function in Power Query
In this exercise, we will learn about the Date.IsInNextYear function in Power Query.
Date.IsInPreviousWeek Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousWeek function in Power Query.
Date.IsInPreviousYear Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousYear function in Power Query.
Date.IsInPreviousMonth Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousMonth function in Power Query.
Date.IsLeapYear Function in Power Query
In this exercise, we will learn about the Date.IsLeapYear function in Power Query.
Date.MonthName Function in Power Query
In this exercise, we will learn about the Date.MonthName function in Power Query.
Date.QuarterOfYear Function in Power Query
In this exercise, we will learn about the Date.QuarterOfYear function in Power Query.
Date.IsInPreviousDay Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousDay function in Power Query.
Date.IsInNextMonth Function in Power Query
In this exercise, we will learn about the Date.IsInNextMonth function in Power Query.
Date.IsInPreviousQuarter Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousQuarter function in Power Query.
Date.Month Function in Power Query
In this exercise, we will learn about the Date.Month function in Power Query.
Date.StartOfYear Function in Power Query
In this exercise, we will learn about the Date.StartOfYear function in Power Query.
Date.IsInCurrentYear Function in Power Query
In this exercise, we will learn about the Date.IsInCurrentYear function in Power Query.
Date.IsInCurrentMonth Function in Power Query
In this exercise, we will learn about the Date.IsInCurrentMonth function in Power Query.
Date.ToRecord Function in Power Query
In this exercise, we will learn about the Date.ToRecord function in Power Query.
Date.WeekOfYear Function in Power Query
In this exercise, we will learn about the Date.WeekOfYear function in Power Query.
Date.FromText Function in Power Query
In this exercise, we will learn about the Date.FromText function in Power Query.
Date.IsInPreviousNYears Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNYears function in Power Query.
Date.IsInPreviousNQuarters Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNQuarters function in Power Query.
Date.IsInPreviousNMonths Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNMonths function in Power Query.
Date.IsInPreviousNDays Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNDays function in Power Query.
Date.IsInPreviousNWeeks Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNWeeks function in Power Query.
Date.IsInNextDay Function in Power Query
In this exercise, we will learn about the Date.IsInNextDay function in Power Query.
Date.IsInCurrentMonth Function in Power Query
In this exercise, we will learn about the Date.IsInCurrentMonth function in Power Query.
Date.ToRecord Function in Power Query
In this exercise, we will learn about the Date.ToRecord function in Power Query.
Date.WeekOfYear Function in Power Query
In this exercise, we will learn about the Date.WeekOfYear function in Power Query.
Date.FromText Function in Power Query
In this exercise, we will learn about the Date.FromText function in Power Query.
Date.IsInPreviousNYears Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNYears function in Power Query.
Date.IsInPreviousNQuarters Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNQuarters function in Power Query.
Date.IsInPreviousNMonths Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNMonths function in Power Query.
Date.IsInPreviousNDays Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNDays function in Power Query.
Date.IsInPreviousNWeeks Function in Power Query
In this exercise, we will learn about the Date.IsInPreviousNWeeks function in Power Query.
Date.IsInNextDay Function in Power Query
In this exercise, we will learn about the Date.IsInNextDay function in Power Query.
🔢 Number Functions in Power Query
Number.RoundUp Function of Power Query
Learn how to round numbers upward to the nearest value using the Number.RoundUp function.
Number.RoundDown Function of Power Query
Round numbers downward to the nearest value using the Number.RoundDown function.
Number.Mod Function of Power Query
Calculate the remainder of a division operation using Number.Mod.
Number.IsOdd Function of Power Query
Check whether a number is odd using the Number.IsOdd function.
Number.IsEven Function of Power Query
Determine whether a number is even using Number.IsEven.
Number.Round Function of Power Query
Round numeric values to a specified number of digits using Number.Round.
Number.Abs Function of Power Query
Return the absolute value of a number using Number.Abs.
Number.Sqrt Function of Power Query
Calculate the square root of a number using Number.Sqrt.
Number.IntegerDivide Function of Power Query
Perform integer division where the remainder is discarded.
Number.Sign Function of Power Query
Determine whether a number is positive, negative, or zero.
Number.Random Function of Power Query
Generate a random decimal number between 0 and 1.
Number.RandomBetween Function of Power Query
Generate a random integer between two specified numbers.
⏱ Duration Functions in Power Query
#duration Function in Power Query
Create duration values representing days, hours, minutes, and seconds.
Duration.TotalSeconds Function in Power Query
Convert a duration value into total seconds.
Duration.Hours Function in Power Query
Extract the hour component from a duration value.
Duration.Days Function of Power Query
Return the day component from a duration value.
Duration.TotalDays Function of Power Query
Convert duration values into total days.
Duration.Minutes Function of Power Query
Extract the minutes component from a duration value.
Duration.Seconds Function of Power Query
Extract the seconds component from a duration value.
Duration.TotalMinutes Function of Power Query
Convert duration values into total minutes.
Duration.TotalHours Function of Power Query
Convert duration values into total hours.
Duration.ToRecord Function of Power Query
Convert duration values into a structured record format.
🔢 Value Functions in Power Query
Value.Divide Function of Power Query
Learn how to divide numeric values using the Value.Divide function.
Value.Compare Function of Power Query
Compare two values and return their relational order.
Value.Add Function of Power Query
Perform addition operations using the Value.Add function.
Value.Subtract Function of Power Query
Subtract numeric values using the Value.Subtract function.
Value.FromText Function of Power Query
Convert text values into numeric or typed values.
Value.Type Function of Power Query
Determine the data type of a given value in Power Query.
📅 DateTime Functions in Power Query
#datetime Function in Power Query
Learn how to create a DateTime value using the #datetime constructor in Power Query.
DateTime.ToRecord Function in Power Query
Convert a DateTime value into a record containing date and time components.
DateTime.IsInPreviousNSeconds Function in Power Query
Check whether a DateTime value occurs within the previous N seconds.
DateTime.IsInPreviousNMinutes Function in Power Query
Determine if a DateTime value falls within the previous N minutes.
DateTime.IsInPreviousNHours Function in Power Query
Identify whether a DateTime value occurred within the previous N hours.
DateTime.IsInCurrentSecond Function in Power Query
Check if a DateTime value falls within the current second.
DateTime.IsInCurrentMinute Function in Power Query
Determine whether a DateTime value occurs within the current minute.
DateTime.IsInCurrentHour Function in Power Query
Check if the DateTime value falls within the current hour.
DateTime.IsInNextSecond Function in Power Query
Evaluate whether the DateTime value occurs in the next second.
DateTime.IsInNextMinute Function in Power Query
Check whether a DateTime value falls in the next minute.
DateTime.IsInNextHour Function in Power Query
Determine if the DateTime value occurs within the next hour.
DateTime.IsInPreviousSecond Function in Power Query
Identify if a DateTime value belongs to the previous second.
DateTime.IsInPreviousMinute Function in Power Query
Check whether a DateTime value falls in the previous minute.
DateTime.IsInPreviousHour Function in Power Query
Determine if a DateTime value occurred within the previous hour.
DateTime.IsInNextNSeconds Function in Power Query
Evaluate if the DateTime value occurs within the next N seconds.
DateTime.IsInNextNMinutes Function in Power Query
Check whether the DateTime value falls within the next N minutes.
DateTime.IsInNextNHours Function in Power Query
Determine if a DateTime value falls within the next N hours.
DateTime.LocalNow Function in Power Query
Retrieve the current local date and time from the system.
DateTime.FixedLocalNow Function in Power Query
Return a fixed DateTime value representing the current local time.
DateTime.AddZone Function in Power Query
Add a time zone offset to a DateTime value.
DateTime.Time Function in Power Query
Extract the time component from a DateTime value.
DateTime.Date Function in Power Query
Extract the date portion from a DateTime value.
🔍 Logical Functions in Power Query
⏰ Time Functions in Power Query
#time Function in Power Query
Create time values using hour, minute, and second parameters.
Time.Second Function in Power Query
Extract the seconds component from a time value.
Time.Minute Function in Power Query
Extract the minute component from a time value.
Time.Hour Function in Power Query
Retrieve the hour value from a time data type.
Time.StartOfHour Function
Return the beginning of the hour for a given time value.
Time.EndOfHour Function
Return the last moment within the hour for a given time.
Time.From Function
Convert various values into a Time data type.
Time.ToText Function
Convert Time values into formatted text strings.
Time.FromText Function
Convert text values into Time data type values.
Time.ToRecord Function
Convert Time values into record components.
🕒 DateTimeZone Functions in Power Query
#datetimezone Function in Power Query
Learn how to create DateTimeZone values including date, time, and timezone information in Power Query.
DateTimeZone.FixedUtcNow Function in Power Query
Retrieve the current UTC time that remains constant during the query evaluation.
DateTimeZone.UtcNow Function in Power Query
Return the current UTC date and time during query execution.
DateTimeZone.LocalNow Function in Power Query
Get the current local date and time based on your system timezone.
DateTimeZone.FixedLocalNow Function in Power Query
Retrieve a fixed local time value that does not change during query refresh.
DateTimeZone.ToRecord Function in Power Query
Convert a DateTimeZone value into a record containing its components.
DateTimeZone.From Function in Power Query
Convert values such as text or datetime into DateTimeZone format.
DateTimeZone.ToUtc Function in Power Query
Convert a DateTimeZone value into UTC time.
DateTimeZone.RemoveZone Function in Power Query
Remove timezone information and convert to a simple datetime value.
DateTimeZone.SwitchZone Function in Power Query
Change the timezone offset of a DateTimeZone value.
DateTimeZone.ZoneMinutes Function in Power Query
Extract the timezone offset minutes from a DateTimeZone value.
DateTimeZone.ZoneHours Function in Power Query
Return the timezone offset hours from a DateTimeZone value.
DateTimeZone.ToLocal Function in Power Query
Convert a DateTimeZone value to the system's local timezone.
🔪 Splitter Functions in Power Query
Splitter.SplitTextByDelimiter Function in Power Query
Learn how to split text values based on a delimiter such as comma, space, or custom characters.
Splitter.SplitByNothing Function in Power Query
Understand how to return the entire value as a single element without performing a split.
Splitter.SplitTextByLengths Function in Power Query
Split text based on specific character lengths for structured text processing.
Splitter.SplitTextByPositions Function in Power Query
Divide text values based on predefined position indexes within the string.
Splitter.SplitTextByWhitespace Function in Power Query
Split text values wherever whitespace characters appear.
Splitter.SplitTextByRanges Function in Power Query
Split text using defined ranges of characters within the string.