Vlookup vs. relationships between two tables or more

[Caze982]

[FONT=&quot]Hi

If i have two tables and if i create a realtionship between them (they could be two lookup tables, two data tables or one datatable and one lookuptable) would it be the same as using vlookup if i was using exel and i theory create one big table?. If this is true does candinality and filter flow affect this or does cardinality and filterflow only affect my data model if i have more than two tables?

Sincerly
Christian[/FONT]

 

[bobby_smith]

Look into power query Merge feature. You should also look into the append feature.