Forum Discussion
Related Dax not working
Hi edithees ,
It seems you are adding a custom column in Power Query Editor, but the RELATED function is used for DAX. You can create a measure as below using related function:
Sales[Sales at List Price] = SUMX ( Sales, Sales[Quantity] * RELATED ( 'Product'[List Price] ) )By the way, what do you want to do with the RELATED function? Perhaps you can provide us with some sample data and calculation logic, and we will provide you with a suitable solution later. The following blog describes related usage scenarios, please check it out. We hope it will be useful to you.
Get a field value from a related table in Power BI: DAX RELATED Function Explained
Best Regards
Super Useredithees , You can use related using 1 from M to side
related([#Years taught index])
otherwise you can use relatedtable and Minx etc
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
Thank you!