Restricted to visual calculations, this DAX function reads a value from the final position along one of the visual's axes. Writing INDEX(-1) gives the same result.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains LAST in context, with comparison tables and the common traps.
Terms in this definition
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Index
Speeds up queries that filter on certain columns by keeping those columns sorted, with pointers back to each row; the price is more storage and slower writes.
Related terms
- Activity explorer
A Microsoft Purview view of the last 30 days of events involving sensitive or labelled items, for example a label being added, altered or taken off, or a DLP rule being triggered. Its data comes from the unified audit log.
- Audit attributes
Columns you can choose to add to fact or dimension tables to log the history of each row, such as the date it was inserted, the date it was last updated, or which ETL job made the change.
- Authentication policy
Lets administrators control how long Kerberos ticket-granting tickets last for chosen accounts and under what conditions they may access things. Introduced as an AD DS object at the Windows Server 2012 R2 domain functional level.
- Autopatch groups
A way of grouping devices in Windows Autopatch, joining Microsoft Entra groups to update policies. Each includes a Test ring and a Last ring with room for up to 15 deployment rings, and one tenant can create 300 of them.
- Azure Information Protection
Service that classifies and protects documents in Office apps, applying a single label to each (if several match, the last one in the policy wins). Its classic client has been retired, with Microsoft Purview sensitivity labels taking over.
- CALENDARAUTO
Scans the model for its first and last dates and returns a continuous Date column covering complete calendar years, or fiscal years when you pass a year-end month. As later dates arrive through refresh, this DAX function's range grows to include them.
- Continuous job
A Lakeflow job whose continuous trigger launches a fresh run the moment the last one finishes. For keeping a pipeline running non-stop, Databricks prefers this to the pipeline's own Continuous mode.
- Data API builder
Turns tables, views and stored procedures into secured REST, GraphQL and MCP endpoints (the last as SQL MCP Server). It's open source, you host it yourself, and a JSON file sets it up, permissions by role included.