Forum Discussion
Libin7963
Helper II
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?
Idrissshatila
Super User
Super UserHello 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/
Libin7963Helper II
Helper IIDoes 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