New to DAX . . . simple RELATED

Jeffrey Green

Well-known Member
Joined
Oct 24, 2007
Messages
1,017
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?

thanks
 
Last edited:

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Jeffrey Green

Well-known Member
Joined
Oct 24, 2007
Messages
1,017
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
Joined
Oct 24, 2007
Messages
1,017
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
 

theBardd

Rules violation
Joined
Jan 21, 2012
Messages
912

ADVERTISEMENT

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top