CONCATENATEX with PARALLELPERIOD or DATEADD does not return the expected value

[Desarrollador9J]

Hi everybody

I have the following meassure:

SelectedDates = CALCULATE(CONCATENATEX(VALUES(Date[Dates]),Date[Dates]," / "),PARALLELPERIOD(Date[Dates],-12,MONTH))

For example, when I select the following non-consecutive dates: 01-01-2022, 02-01-2022, 05-01-2022

I expected to get the following result:"01-01-2021 / 02-01-2021 / 05-01-2021"

But I get the following result: "01-01-2021 / 02-01-2021 / 03-01-2021 / 04-01-2021 / 05-01-2021"

I have tried to replace PARALLELPERIOD with DATEADD, but I get an error because the dates are not consecutives.

I've tried several solutions including variables without success.

I'm still a beginner. If anyone has any idea how to solve this, I'd really appreciate it.

LJ.

[Desarrollador9J]

This was exactly what I need. Thank you.

[lbendlin · Accepted solution]