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
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi WILSONB,

 

I agree with parry2k, creating an individual Date table should be a possible solution in this scenario.

 

In addition to use Power Query(M) to create the Date table in Query Editor, you can also use CALENDAR or CALENDARAUTO  Function (DAX) to create the Date table in Data Model.

 

And for more information about how to create and manage relationships in Power BI Desktop, please refer to this article.:smileyhappy:

 

Regards