Forum Discussion

clovisantonio's avatar
clovisantonio
Regular Visitor
5 years ago

Filter data with date from another dataset

Hello all,

 

I would like to use specific date filter from one dataset in another dataset. I will try to explain by pictures below:

In this table I have data from specific equipments and I count it by event time (for example one event time in specific format date dd/mm/yyyy hh:mm:ss)

 

I have other dataset with the date I would like to use as filter with other specifics format date dd/mm/yyyy hh:mm:ss)

I've tried to create a day in this dataset in order to make a relationship between them. But, when I try to filter the first dataset does not recognize the filter from the second one.

I believe there is a simple solution to that but I cannot figure it out.

 

Thank you in advance!

 

Clovis

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi,  clovisantonio 

    What is the formula of the new calculated column you added? 

    You can consider creating a calendar table to relate these two tables(one-to-many relationship with bi-directional filter).

     

    Best Regards,
    Community Support Team _ Eason