Related Dax not working

[edithees]

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:)

[v-yiruan-msft · Accepted solution]

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

[amitchandak]

@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=czNHt7UXIe8

[edithees]

Thank you!