Please help

[Anonymous]

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 function to get the value from related table so please suggest me any alternative. Please help its urgent.

[Anonymous]

Hi @Anonymous ,

Any updates?

As @TomMartens mentioned before, the information you have provided is not making the problem clear to us, please provide more details about your table and your expected output to help us clarify your scenario.

Or share your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[TomMartens]

Hey @Anonymous ,

please take the time and create a pbix file that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures), upload the file to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, share the xlsx file as well.

Describe the expected result based on the sample data you provide.

Regards,

Tom

[TomMartens]

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]

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

thanks