Date table relationship with multiple dates in one table

[NessFlood]

I have created a date table and thought I could link it to multiple date fields in another table but it appears I can't.  The CBR-Report table has multiple FC date columns (forecast) and I'm wanting to create a date slicer that would apply to all those date fields at the same time.

I'm wondering if I have to split out the CBR report into multiple tables for SAQ,, SAT etc which have their own FC date columns?

Any help much appreciated!

cheers

Ness

[danextian]

Hi @NessFlood 

You can create only one active relationship between two tables. The additional relationships will be deemed inactive which can be invoked by using USERELATIONSHIP function in a measure.  In the screenshot below, the ones with broken lines are inactive. Please read this: Active vs inactive relationship guidance 

Please see the attached pbix for the details.