Forum Discussion

Natalia10000's avatar
Natalia10000
Frequent Visitor
2 years ago
Solved

List of dates from previous Year

I would like to write DAX formula which would take a selected list of dates and provide me with the same dates but from Last year,   List of currecnt dates: VAR weeksel = CALCULATETABLE(VALUES('D...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Natalia10000 ,

     

    You can try the following DAX:

    FILTER(ALL('Date'),
    'Date'[Date]>=
EDATE(MIN('Date'[Date]),-12)&&'Date'[Date]<=TODAY())

    Refer to :

    EDATE function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Natalia10000 ,

 

You can try the following DAX:

FILTER(ALL('Date'),
    'Date'[Date]>=
EDATE(MIN('Date'[Date]),-12)&&'Date'[Date]<=TODAY())

Refer to :

EDATE function (DAX) - DAX | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.