Forum Discussion
Solved
Look up tables
Hi there, In my Power BI desktop i have 2 different sources of data, one is coming from a simple excel file while the other one is coming from our marketing platform Eloqua. In both set of data ...
You can use LOOKUPVALUE to get the ID from table 2 onto table 1
ID = LOOKUPVALUE(Table2[ID],Table2[Email],Table1[Email])This will pull the ID from table 2 onto table 1 only where the email matches.
My ID's start at 1 just bacause I assigned an index column for the example.
Hi there,
Actually i have already something like that in place, the 2 tables are actually linked to each other. However i would like to have a numeric value cause in the future I would like to build a Venn diagramm and from my understanding I need numerical values to do that.
Thanks,
Ale
You can use LOOKUPVALUE to get the ID from table 2 onto table 1
ID = LOOKUPVALUE(Table2[ID],Table2[Email],Table1[Email])This will pull the ID from table 2 onto table 1 only where the email matches.
My ID's start at 1 just bacause I assigned an index column for the example.