Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |