A = = General X Cortar Coper Copiar formato Callbei 11 A* NKS - 3. A.A. E Ajustar texto combinar y centra - Insertar Eliminar Formato s $ . % 0 38 Formato Dar formato Estilos de condicional - como tabla - celda - Nmero Caldas 1 X Sales Rep A B C D E F G H 1 Highline Excel 2016 Class 14: Think of VLOOKUP as Relationship in Data Model and Vice Versa I M SalesRef Region Sioux Canada Han United States Kip South America 3 Date SalesRefl Sales 4 5/28/2016 Sioux $1,537 5 5/16/2016 Sioux $5,959 6 5/25/2016 kip $1,380 7 5 /21/2016 Sioux $6,652 8 5 /23/2016 Han $10,690 5/11/2016 Han $1,513 5/13/2016 Sioux $8,767 11 5/25/2016 Kip $7,921 12 5/25/2016 Sioux $8,419 13 5/16/2016 Sioux $2,769 5/10/2016 Sioux $3,439 5/26/2016 Sioux $1,036 5/27/2016 Han $7,578 10 VLOOKUP: 1) When data set is not big 2) Your data sets are already in the Excel Workbook File 3) Quick and easy solution for 1 or 2 lookup columns Relationship in Data Model: 1) You have big data 2) You need to build a complex Data Model with relationships between many tables. 3) DAX Formulas can be built once and have Number Formatting attached to formula A = = General X Cortar Coper Copiar formato Callbei 11 A* NKS - 3. A.A. E Ajustar texto combinar y centra - Insertar Eliminar Formato s $ . % 0 38 Formato Dar formato Estilos de condicional - como tabla - celda - Nmero Caldas 1 X Sales Rep A B C D E F G H 1 Highline Excel 2016 Class 14: Think of VLOOKUP as Relationship in Data Model and Vice Versa I M SalesRef Region Sioux Canada Han United States Kip South America 3 Date SalesRefl Sales 4 5/28/2016 Sioux $1,537 5 5/16/2016 Sioux $5,959 6 5/25/2016 kip $1,380 7 5 /21/2016 Sioux $6,652 8 5 /23/2016 Han $10,690 5/11/2016 Han $1,513 5/13/2016 Sioux $8,767 11 5/25/2016 Kip $7,921 12 5/25/2016 Sioux $8,419 13 5/16/2016 Sioux $2,769 5/10/2016 Sioux $3,439 5/26/2016 Sioux $1,036 5/27/2016 Han $7,578 10 VLOOKUP: 1) When data set is not big 2) Your data sets are already in the Excel Workbook File 3) Quick and easy solution for 1 or 2 lookup columns Relationship in Data Model: 1) You have big data 2) You need to build a complex Data Model with relationships between many tables. 3) DAX Formulas can be built once and have Number Formatting attached to formula