Concatenate values between a period

[sebastian_ebg]

I'm trying to get a comma separated list of all the values in a field that relate to an individual time period. There can be multiple overlapping promotions, hence the use of CONCATENATEX().

The data model I have is quite simple:

I can get the exact desired effect as a calculated column in the DateCal table by using the following formula: Current Promotions = CALCULATE(CONCATENATEX(Promotions,Promotions[Promo Name],", "),FILTER(Promotions,Promotions[Begin Date]<=DateCal[Date]&&Promotions[End Date]>=DateCal[Date]))

I just can't get the formula to work as a measure so that I can dynamically filter based on date (and add it as a tooltip).

What am I missing to get this working?

[sebastian_ebg · Accepted solution]

I managed to work this out myself using effectively the same formula. It now works perfectly for what I need it for.

Will leave the post here if anyone else has the same question 🙂

Promotions =
CALCULATE (
    CONCATENATEX ( Promotions, Promotions[Promo Name], ", " ),
    FILTER ( ALL ( Promotions ), Promotions[Begin Date] <= MAX ( DateCal[Date] ) ),
    FILTER ( ALL ( Promotions ), Promotions[End Date] >= MIN ( DateCal[Date] ) )
)