PowerQuery M Reference Guide
Accessing data functions
Binary functions
Combiner functions
Comparer functions
Date functions
DateTime functions
DateTimeZone functions
Duration functions
Error handling
Expression functions
Function values
Lines functions
List functions
List.Accumulate
List.AllTrue
List.Alternate
List.AnyTrue
List.Average
List.Buffer
List.Combine
List.ConformToPageReader
List.Contains
List.ContainsAll
List.ContainsAny
List.Count
List.Covariance
List.Dates
List.DateTimes
List.DateTimeZones
List.Difference
List.Distinct
List.Durations
List.FindText
List.First
List.FirstN
List.Generate
List.InsertRange
List.Intersect
List.IsDistinct
List.IsEmpty
List.Last
List.LastN
List.MatchesAll
List.MatchesAny
List.Max
List.MaxN
List.Median
List.Min
List.MinN
List.Mode
List.Modes
List.NonNullCount
List.Numbers
List.Percentile
List.PositionOf
List.PositionOfAny
List.Positions
List.Product
List.Random
List.Range
List.RemoveFirstN
List.RemoveItems
List.RemoveLastN
List.RemoveMatchingItems
List.RemoveNulls
List.RemoveRange
List.Repeat
List.ReplaceMatchingItems
List.ReplaceRange
List.ReplaceValue
List.Reverse
List.Select
List.Single
List.SingleOrDefault
Syntax
About
List.Skip
List.Sort
List.Split
List.StandardDeviation
List.Sum
List.Times
List.Transform
List.TransformMany
List.Union
List.Zip
PercentileMode.ExcelExc
PercentileMode.ExcelInc
PercentileMode.SqlCont
PercentileMode.SqlDisc
Logical functions
Number functions
Record functions
Replacer functions
Splitter functions
Table functions
Text functions
Time functions
Type functions
Uri functions
Value functions
PowerQuery M Reference Guide
»
List functions
»
List.SingleOrDefault
View page source
List.SingleOrDefault
Microsoft Docs:
List.SingleOrDefault
Syntax
Syntax
for
this
function
.
About
About this function.