Forum Discussion

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('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
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.

4 Replies

khaledHabib90
Resolver II
2 years ago
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
  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
    Frequent Visitor
    2 years ago
    To be more specific the dates that I have is the random selection of days
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.