Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Helper V
5 years ago
Solved

USERELATIONSHIP not working

Hi,   I have a DAX code below that doesn't seem to activate the correct relationship on my data model. The SUM is correct, but it returns on the wrong date. What is wrong and how to fix? In the ...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi CarlsBerg999 ,

     

    The userelationship function specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2. Since no detailed data model is provided, you can check whether the [Work Started on Task] field in ‘Table1’ meets the requirements based on the information provided in the official website document below, and try again after modifying it.

    Check the document link.


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VijayP's avatar
VijayP
Community Champion
5 years ago

CarlsBerg999 

USERELATIONSHIP works on similar columns viz.., Date in Date Table and date in another table

In your example, if  Workstarted on Task is Date  then use VALUES(‘Table1’[Work Started on Task])

Let me know if any assitance required