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

[SanketBhagwat]

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

[MFelix · Accepted solution]

Hi @SanketBhagwat ,

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

[SanketBhagwat]

Thanks @MFelix 

Just a silly mistake.

Regards,

Sanket Bhagwat