Forum Discussion

Charcoal55's avatar
Charcoal55
Regular Visitor
1 year ago
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...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Charcoal55 ,

     

    try like:

     

    FILTER(

            ALL(Dates),

            Dates[Date] <= EDATE(MAX(Dates[Date]), -12) 

        )

     

    EDATE is not time intelligence function and thus less picky.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Charcoal55 , Formula is correc

DAX
FILTER(
ALL(Dates),
Dates[Date] <= DATEADD(MAX(Dates[Date]), -1, YEAR)
)

 

Just ensure that

The Dates table is properly related to other tables in your data model.
The filter context is correctly applied.
There are no syntax errors or other issues in the broader DAX expression where this formula is used.