Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Please help

Can anyone tell me that how to create calculated column by taking values from separate table joined with many to many relationship because I ma trying and its not working I have used rekated fu...
Need Help
TomMartens's avatar
TomMartens
Super User
4 years ago

Hey Anonymous ,

 

you can't use the function RELATED because of the nature of the relationship, RELATED can be used to pull a value from the 1-side of a relationship into the many-side.

 

Use LOOKUPVALUE instead: LOOKUPVALUE – DAX Guide

 

Hopefully, this helps to tackle your challenge.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    TomMartens  can you please give me full condition using my above condition that would be appreciated .

    thanks