How to link/assosiation user defined dates table to master calendar.

[ramrongala]

HI experts,

below is the user defined table(dates maybe changed by the user in often)

Period ID	Calculation Start	Calculation End	Send Date	Effected Date
001	1/1/2021	3/31/2021	4/15/2021	5/1/2021
002	4/1/2021	6/30/2021	7/15/2021	8/1/2021
003	7/1/2021	9/30/2021	10/15/2021	11/1/2021
004	10/1/2021	12/31/2021	1/15/2022	2/1/2022

I have master calendar also, how can I link to master calendar.

user wants the filter(period)  to be like combination of 3 columns (P4PPeriodID-KPICalculationStart-KPICalculationStart)

now if user selects 1st value(001-01/01/2021-31/03/2021) then show the dates from 01/01/2021to 31/03/2021 in dashboard

if user selects 2nd value(001-04/01/2021-30/06/2021) then show the dates from 04/01/2021 to30/06/2021 in dashboard

please help me how to achieve this one.

[JuanGerardo]

Hi @ramrongala, I think you can use a link table between periods and calendar dates, so you have all dates for every period, and if you select a period you will associate with corresponding dates in calendar. An example:

Calendar
--------
Date
1/1/2021
2/1/2021
3/1/2021

Link Table
------------------------------------
Period                    | Date
From 1/1/2021 To 2/1/2021 | 1/1/2021
From 1/1/2021 To 2/1/2021 | 2/1/2021
From 2/1/2021 To 3/1/2021 | 2/1/2021
From 2/1/2021 To 3/1/2021 | 3/1/2021

JG