Forum Discussion
Is this date between Start & End Date? with PowerBI
Normally, you wouldn't filter one dimension with another dimension. What I mean by that is, you wouldn't expect to see all the countries (Geography dimension) for January (Date dimension). However, you can filter it once you bring the context of a fact/measure. For eg, you can filter all the countries that had Sales (measure) for January.
That said, if you had a measure (maybe like number of hours), I can suggest the method to filter all the projects where the selected dates are between the start dates and end date. The pattern here is to create a disconnected Date table (a table with the list of dates, which has no relationship to the fact table) and then create a measure which will display value only for projects where the dates are between start and end dates. That pattern is also explained in the blog below.
http://www.powerpivotblog.nl/get-values-within-a-start-and-end-date-using-powerpivot-dax/