Forum Discussion

fwdatageek's avatar
fwdatageek
Regular Visitor
6 years ago
Solved

DAX command error when using USERELATED function to handle multiple dates

Hi 

 

I am trying to create a relationship in a table with multiple date fields. My Master Date Table is the 'CY Date Format' and the existing relationship is between that date and the (Opportunity[ClosedDate]. How do I create a connection between the (Opportunity[ClosedDate] and the (Opportunity[CreatedDate]? I continually get the error below now matter which way I try! 

 

 

  • Can't be certain, but it looks like you have not created the second relationship. The second relationship between the tables will  be inactive but it has to be there for USERELATIONSHIP to work.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Can't be certain, but it looks like you have not created the second relationship. The second relationship between the tables will  be inactive but it has to be there for USERELATIONSHIP to work.