Text: X Conar Copiar Copr
Calibni
-11 AA
I
Ajustar texto
General
&
A
%
Formato Dar formato Estilos de -comotabla- celda-
Formato
Estilos
H3
x
SalesRep
D
E G Highline Excel 2016 Class 14: Think of VLOOKUP as Relationship in Data Model and Vice Versa
M
Date SalesReSales . 5/28/2016Sioux $1,537 5/16/2016Sioux 656'SS 5/25/2016Kip $1,380 5/21/2016Sioux $6,652 5/23/2016Han $10,690 9 5/31/2016Han $1,513 5/13/2016Sioux $8,767 115/25/2016Kip $7,921 125/25/2016Siou $8,419 135/16/2016Sioux $2,769 145/30/2016S1ou $3,439 155/26/2016S $1,036 165/27/2016Han $7,578 7 18 19 20 21 22 23
SalesRegReglon Sioux Canada Han United States Kip South America
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