Last Sunday of the Month

DAX DAX Calculations
2

Hi @JamesDavies,

Give this a go

Last Sunday in March =
VAR d = DATE( YEAR(TODAY()), 3, 1)
VAR r = EOMONTH( d, 0) - MOD( WEEKDAY(EOMONTH( d, 0), 11), 7)
RETURN r
2 Likes