Common Date Control for two different datasets

Q&A
,
1

Hi Experts,
Need to implement Common date Control for two different Datasets.
I cannot add a date control from any one dataset due to missing dates.
Is it possible to achieve this or any work around?

2

Hi @syed_imran
do i get it right.
You want to create a date filter but dont have any dates within your datasets?
BR

3

Hi @ErikG ,
I have two datasets.
Dateset1: Dateset2:
DateColumn DateColumn
2023-12-01 2023-11-05
2023-12-02 2023-11-06
2023-12-03 2023-11-07
2023-12-04 2023-11-08
I wanted to add a control which shows all the dates from Dateset1 and Dataset2 so that it can be filterable.

4

Hi @syed_imran
you can create a date parameter, set a date filter for each dataset and use the parameter as control.
BR

5

But the control should be linked to a date field (Dates from Dataset1 and Dataset2) so that all the dates are available in the control.

6

If your parameter is a date type you will get automatically all dates.

7

oh is it?
I did not know this.
Thanks for letting me know.Will give it a try.

1 Like