Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have an active relationship between 2 tables, table 1 & 2.
However when i try to have a New Column in table 2 by using "RELATED" function, it never shows table 1 and i couldnt pick the corresponding value from table 1.
Any comment on how to solve this ?
Solved! Go to Solution.
RELATED function can only be used in the many side. Just think if we use it in the one side, there will be multiple values related to a single value, which one should be returned in only one cell?
Best Regards,
Herbert
Thanks Herbert. I realised that when i made the last comment.
Thanks for your time.
Regards
Prabhu
RELATED function can only be used in the many side. Just think if we use it in the one side, there will be multiple values related to a single value, which one should be returned in only one cell?
Best Regards,
Herbert
Is the relationship ‘many to one’ or ‘one to one’? If it is ‘many to one’, did you create the related column in the ‘many’ side?
I tried on Feb 2017 version of Power BI Desktop but cannot repro the same issue as you.
Best Regards,
Herbert