New to DAX . . . simple RELATED

Jeffrey Green

Well-known Member
i did this years ago, but cant replicate what i did.

I have Table1 and Table2 and with a relationship of Column1 = Column1.
there is only one column in table1 and two columns in table 2.

All i want to do is bring in the value in Column2, called junk, into Table1.

There are 500,000 rows in both, and using Related is WAY faster than vlookup.

i am using =RELATED(Table2[junk] in a calculated column in table1. it errors, "table1 calc column has syntax error"

1. i do this in the data model right? not the exdel?
2. how do i toggle between the data model and the excel workbook?

Last edited:

Jeffrey Green

Well-known Member
ah, it seems like my relationship isnt staying as i set it. i am setting TABLE1/Column1 = Table2/Column1. But when i look at it again in MANAGE RELATIONSHIPS, it reversed. and if i do the RELATED fuction in table2, i works, pulling data from table1. Thoughts?

Jeffrey Green

Well-known Member
I did at the beginning; I thought fixed that; but i re-did entire process from the start . . it is ok now . . . BUT
I was able to do my RELATED in the Data Model, but how do i update the EXCEL workbook? thanks


Rules violation
Maybe the best way is to do it in Power Query rather than PowerPivot (using Merge Queries) and load the results to a new table in Excel.

Some videos you may like

This Week's Hot Topics