How do I use the selected period to filter other dates?

[OC_BI]

Hello,

We have a fact table where the measures are associated with 3 dates: A, B and C dates.  The report currently filters using A date.  The report sums up values from the fact table based on the selected period in the slicer (A date).  

The problem I'm trying to overcome is:

How do I use the selected period to filter the other dates ? 

I'm trying to add the same set of measures with different logic:

B date in selected period

C Date < selected period

For example - I selected the current year and the report displays all the measures whose A date is this year, i.e.: 01/01/2019 - 24/03/2019

Now I'd like to add all the measures with:

B date < 01/01/2019

and 

C date between 01/01/2019 - 24/03/2019.

I'm new to Power BI and all help will be appreciated.

OC

[edhans · Accepted solution]

You need a single date table, and use that date field in your slicer.

If your A, B, and C dates are in separate tables, just relate them all to the Dates[Date] field in your date table.

If they are in the same table, it gets a bit trickier. You still relate all of them, but only one can be active. You can use the other "inactive" relationships in a measure with CALCULATE() in it if you use the USERELATIONSHIPS() function as one of the filters.

See this article on setting update tables.

The USERELATIONSHIPS() function will activate an inactive relationship for the current measure.

If you need additional help, you'll need to post some sample data in text format.