Forum Discussion
Related Dax not working
Hi, need some help with RELATED.
1. Related isn't coming up as a formula to me.
2. But it lets me put in something like this Column=related(#"Years taught index")) and when I click ok, I get Expression.Error: The name 'Related' wasn't recognized. Make sure it's spelled correctly. What I see in the formula became = Table.AddColumn(#"Removed Columns1", "Custom", each Related(#"Years taught index")). The Years taught index is the new table and within it I have a column called Years taught index.
3. The relationship between the 2 tables is many to one and it's active, the name of the columns are identical.
I'm not sure what is the problem...please help:)
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
3 Replies
- amitchandak
Super User
edithees , 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=czNHt7UXIe8Thank you!
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
