Forum Discussion
Filtering multiple Dates across multiple queries with an existing relationship
Hey All,
I work with WILSONB and I wanted to help clear up the ask.
We already have an existing relationship between the two tables that is essential to the report. We tried to create a calendar table and create that relationship, however this existing relationship would not allow it. We were wondering if there was any other way to work around this.
There are dates in both sets and we just want to make sure that everyone is looking at the same range within both tables. The other option for us was to create filters on both data sets for a moving date range, but we would prefer it to remain dynamic.
Does that make sense?
Cool,
1. Create on Date Master table.
Example : Use this code create Table in Dax :
calender = CALENDAR(DATE(2016,1,1),DATE(2016,12,31))
It will give u new table from 1-jan-2016 to 31-12-2016
2. Link the Date master with yout two table . (Miles Data and Accident Data),
Before that u have to Change the bi-Direction filter to single direction on already existing table connection, don't forgot it.
Then use date slicer from date master.
Try this if it is not helps u let me know i will help u
Not sure if it is clear. May be you need to provide some more informaton. This is what I understood:
- Mile Data is linked to Cost Center table on cost center field
- Accident Data is linked to Cost Center table on Service Center (i believe)??
Miles and Accident are not related to each other what I see from diagram, is this correct understanding?
