Forum Discussion
Helper IILimited relation for Dimension Date table
Hi all,
My Date table has limited relation as I have data from multiple sources for other tables. I can't use the related function to pull data from many side, is there any work around?
4 Replies
- Idrissshatila
Super User
Hello Libin7963 ,
if you mean you want to activate an inactive relationship, then you can do that in the measure using the userelationship dax function.
check it out https://www.sqlbi.com/articles/using-userelationship-in-dax/
Libin7963Does Userelationship work in limited relation tables as it is not working for me
. Found this in MS learning portal
- Idrissshatila
ohh now I see, then try using lookup value https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax
check my youtube channel https://www.youtube.com/@PowerBISolution
Hi, Libin7963
Can you provide some sample data and the output you expect? Sensitive data can be removed in advance.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
