Forum Discussion
retrieve values from a Non active relationship table
- 3 years ago
jtpiazzamn You can get a new column in the Evaluation table
maxx(filter(Ideas, Ideas[ID] = Evaluation[Idea id]) ,Ideas[Name])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8or use userelationship to activate join, if this a valid inactive join https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi
jtpiazzamn You can get a new column in the Evaluation table
maxx(filter(Ideas, Ideas[ID] = Evaluation[Idea id]) ,Ideas[Name])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
or use userelationship to activate join, if this a valid inactive join https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi