Forum Discussion
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 function to get the value from related table so please suggest me any alternative. Please help its urgent.
4 Replies
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
TomMartens can you please give me full condition using my above condition that would be appreciated .
thanks
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
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
