Forum Discussion
Solved
DATEADD and MAX?
Hi, I understand that the below filter function returns a table containing all dates in the date table and where the latest date in that table is defined by the filter context. Thus, if the date tab...
hi Charcoal55 ,
try like:
FILTER(
ALL(Dates),
Dates[Date] <= EDATE(MAX(Dates[Date]), -12)
)
EDATE is not time intelligence function and thus less picky.
FreemanZ
Super User
Super Userhi Charcoal55 ,
try like:
FILTER(
ALL(Dates),
Dates[Date] <= EDATE(MAX(Dates[Date]), -12)
)
EDATE is not time intelligence function and thus less picky.