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

 

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

FIRSTDATE
LASTNONBLANK
FIRSTNONBLANK

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI