List of dates from previous Year

[Natalia10000]

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('Date'[Date]),'Date'[Year Week]=prevYearWeeks+1)

Now I would like to have the same dates but from 1 year earlier, I tried DATEADD as below:

VAR weeksel = CALCULATETABLE(DATEADD('Date'[Date],-364,DAY),'Date'[Year Week]=prevYearWeeks+1)

but if I have random lits of dates that are not continous I got and error.

Could you please help me?

Thank you in advance,

Natalia

[Anonymous · Accepted solution]

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.

[khaledHabib90]

consider using this function:

SAMEPERIODLASTYEAR('Date'[Date])

in the filter Argument of the calculate function

If my reply helped you solve the problem please accept it as the solution 🙂

[Natalia10000]

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

[Natalia10000]

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