Forum Discussion
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-msftCommunity 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