USERELATIONSHIP to change the date of a slicer

[DebbieE]

I have a page of reports that all use an inactive date relationship (date B)

On this page is a Year Slicer. Obviously at the moment its connected to the active date relationship in the Dim Table (Date A)

For this one page Can I create a measure with USERELATIONSHIP in in so I can add the year of the inactive date to the year the slicer?

[parry2k]

@DebbieE Your question is a bit confusing. You have two dates table and a relationship with your transaction tables for both the table or you have one date table and one active and other inactive relationship with your transaction table. Can you provide a bit more details and context? Is it possible to share the relationship diagram and what you are trying to achieve. 

[DebbieE]

Hi, 

I didnt say I had two date tables. I have a date table with an active relationship and an inactive relationship. 

I have a page of reports that all use the inactive date relationship (date B)

On this page is a Year Slicer. Obviously at the moment its connected to the active date relationship in the Dim Table (Date A)

For this one page Can I create a measure with USERELATIONSHIP in it so I can add the year of the inactive date to the year the slicer?

I am asking if you can use an inactive relationship on a date table for the date slicer? If you cant use an inactive join for the date for the slicer I need to rethink my entire model so Im hoping you can use an inactive join under a slicer