Forum Discussion

WILSONB's avatar
WILSONB
New Member
9 years ago

Filtering multiple Dates across multiple queries with an existing relationship

  I have notebook where I have 2 different Data Sets and I already have a relationship exsiting on a particular value but I would like to create a date slicer that allows me to cover 2 different dat...
Need Help
Treyson's avatar
Treyson
Icon for Advocate I rankAdvocate I
9 years ago

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?

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

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