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

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.