Search in date interval

[#1]

If I can´t do an IntervalMatch, can I choose a day in my calender and find the day in my interval in a another way?

[#2 · Accepted solution]

if you use that formula as an expression within a pivot chart (Dimension is ID)

if(Start<=ONLY(CalendarDate) AND Slut >=ONLY(CalendarDate), Start, NULL())

you will get all Start fields which within Start and Slut.

Be aware, only one date must be selected!

Best regards

Michael

[Miguel_Angel_Baeyens]

Hi Viktoria,

Download and check this application on how to use a calendar with variables (storing from and to dates) and how to use them in set analysis.

Hope that helps.

Miguel

[#4]

Thanks for the help!