Picking dates from two calendars

[AgataKK]

Hello,

My end user has the opportunity to choose months in year for comparison to months from previous year. I have two calendars in the dashboard and the user has to pick those dates from both. I would like to make this picking more easy – if the end user picks the dates from 2019, the same dates from 2018 would be picked automatically. What is tricky – months don’t have to be continuous, for example he can pick only September and May.

Does anyone have an idea how to solve this?

[HirisH_V7]

With your Date Fields in UI,

Dates:

Date(AddYears(Max(Date),-1))   // Previous Year Same Date

Date(Max(Date))  //Current Date

Months:

monthName(addmonths(Max(MonthName),-12))  // Previous Year Same Month

Monthname(Max(MonthName)) //Current Date

[HirisH_V7 · Accepted solution]

This is for Multiple Selections,

Months:

=Concat(Distinct MonthName(addmonths(MonthName,-12)),',')  // Previous year months

=Concat(Distinct Monthname(MonthName),',') //Current Year Months

Date:

=Concat(Distinct Date(AddYears(ShipDate,-1)),',')  // Previous year dates

=Concat(Distinct Date(ShipDate),',')  //Current Year Dates

You can use the same in Set analysis for comparison reports.

PFA for ref. Let me know if i missed any.

[AgataKK]

Thank you very much 🙂