DAX Function Guide

LASTDATE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the LASTDATE 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?

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

Related Blog Posts

Loading

Considerations when using the LASTDATE?

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

Loading

Formula examples using the LASTDATE

= LASTDATE (
    ‘InternetSales_USD'[SaleDateKey]
)

Related Courses

Loading