Difference between MAX and LastDate

Power BI
1

Hi there,

I’m currently watching the series about cumulative sales.

In this video the following formula is used:

Cumulative Sales =
CALCULATE( [Total Sales];
FILTER( ALL( Dates[Date] );
Dates[Date] <= MAX( Dates[Date] ) ) )

But I don’t get it when you should use MAX and when LastDate.

When I try

Cumulative Sales =
CALCULATE( [Total Sales];
FILTER( ALL( Dates[Date] );
Dates[Date] <= LASTDATE( Dates[Date] ) ) )

every date in a matrix simply gets the total of all sales for all dates.

2

Hi, Dieffie. I believe that for Cumulative totals you can use both. I found great article if you wanna know more about the difference between those 2 functions.

3 Likes
3

Thanks for sharing the link Ivanka.