This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use.
Learn more
Developer Network
Developer Network
Developer
Sign in
Subscriber portal
Get tools
Downloads
Visual Studio
SDKs
Trial software
Free downloads
Office resources
SharePoint Server 2013 resources
SQL Server 2014 Express resources
Windows Server 2012 resources
Programs
Subscriptions
Overview
Administrators
Students
Microsoft Imagine
Microsoft Student Partners
ISV
Startups
Events
Community
Magazine
Forums
Blogs
Channel 9
Documentation
APIs and reference
Dev centers
Samples
Retired content
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Power Query (M) Formula Reference
Power Query M function reference
Table functions
Table functions
Occurrence.Last
Occurrence.Last
Occurrence.Last
ExtraValues.Error
ExtraValues.Ignore
ExtraValues.List
GroupKind.Global
GroupKind.Local
JoinAlgorithm.Dynamic
JoinAlgorithm.LeftHash
JoinAlgorithm.LeftIndex
JoinAlgorithm.PairwiseHash
JoinAlgorithm.RightHash
JoinAlgorithm.RightIndex
JoinAlgorithm.SortMerge
JoinKind.FullOuter
JoinKind.Inner
JoinKind.LeftAnti
JoinKind.LeftOuter
JoinKind.RightAnti
JoinKind.RightOuter
Occurrence.All
Occurrence.First
Occurrence.Last
Order.Ascending
Order.Descending
RowExpression.Column
RowExpression.From
RowExpression.Row
Table.AddColumn
Table.AddIndexColumn
Table.AddJoinColumn
Table.AddKey
Table.AggregateTableColumn
Table.AlternateRows
Table.Buffer
Table.Column
Table.ColumnCount
Table.ColumnNames
Table.ColumnsOfType
Table.Combine
Table.CombineColumns
Table.Contains
Table.ContainsAll
Table.ContainsAny
Table.DemoteHeaders
Table.Distinct
Table.DuplicateColumn
Table.ExpandListColumn
Table.ExpandRecordColumn
Table.ExpandTableColumn
Table.FillDown
Table.FillUp
Table.FilterWithDataTable
Table.FindText
Table.First
Table.FirstN
Table.FirstValue
Table.FromColumns
Table.FromList
Table.FromPartitions
Table.FromRecords
Table.FromRows
Table.FromValue
Table.Group
Table.HasColumns
Table.InsertRows
Table.IsDistinct
Table.IsEmpty
Table.Join
Table.Keys
Table.Last
Table.LastN
Table.MatchesAllRows
Table.MatchesAnyRows
Table.Max
Table.MaxN
Table.Min
Table.MinN
Table.NestedJoin
Table.Partition
Table.Pivot
Table.PositionOf
Table.PositionOfAny
Table.Profile
Table.PrefixColumns
Table.PromoteHeaders
Table.Range
Table.RemoveColumns
Table.RemoveFirstN
Table.RemoveLastN
Table.RemoveMatchingRows
Table.RemoveRows
Table.RemoveRowsWithErrors
Table.RenameColumns
Table.ReorderColumns
Table.Repeat
Table.ReplaceErrorValues
Table.ReplaceKeys
Table.ReplaceMatchingRows
Table.ReplaceRelationshipIdentity
Table.ReplaceRows
Table.ReplaceValue
Table.ReverseRows
Table.RowCount
Table.Schema
Table.SelectColumns
Table.SelectRows
Table.SelectRowsWithErrors
Table.SingleRow
Table.Skip
Table.Sort
Table.SplitColumn
Table.ToColumns
Table.ToList
Table.ToRecords
Table.ToRows
Table.TransformColumnNames
Table.TransformColumns
Table.TransformColumnTypes
Table.TransformRows
Table.Transpose
Table.Unpivot
Table.UnpivotOtherColumns
Table.View
Tables.GetRelationships
#table
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.
Occurrence.Last
About
The position of the last occurrence of the found value is returned.
Show:
Inherited
Protected
Print
Export (
0
)
Print
Share
IN THIS ARTICLE