LASTDATE Function (DAX)

How does the LASTDATE function (DAX) work?

The LASTDATE function (DAX)  returns the last date for the given column of dates in the current context.

LASTDATE Formula Syntax

LASTDATE(
     <dates>
)

How do you use the LASTDATE function?

A table that contains a single column and a single line with a date number.

Related Blog Posts

Related Support Forum Posts

LASTDATE with conditon
Difference between MAX and LastDate
Multi Day Analysis not working

Considerations when using the LASTDATE function

If the current context is one single date,the dates returned by the function DAX FIRSTDATE the function DAX LASTDATE will be the same.

Related Video Tutorials

Formula examples using the LASTDATE function

= LASTDATE (
    ‘InternetSales_USD'[SaleDateKey]
)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership