Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

USERELATIONSHIP function can only use the two columns references participating in relationship error

Hi Everyone.

 

I was using the USERELATIONSHIP DAX to perform some operation, but was uanble to do so.

I am constantly getting an error as "USERELATIONSHIP function can only use the two columns references participating in relationship".

 

If someone knows any solution, then kindly reply.

I have attached screenshots of the data and the error.

 

Regards,

Sanket Bhagwat

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    Remove the .Date from the Calendar[Date].[Date]

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Anonymous ,

     

    Remove the .Date from the Calendar[Date].[Date]

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks MFelix 

      Just a silly mistake.

       

      Regards,

      Sanket Bhagwat