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.

Natalia10000's avatar
Natalia10000
Frequent Visitor
2 years ago

Hi, thank you for Your response, but this one also needs continuous dates selection? I mean there should be no gaps between dates?

Natalia10000's avatar
Natalia10000
Frequent Visitor
2 years ago

To be more specific the dates that I have is the random selection of days