Vlookup and Power BI Advanced Editor

[EWilson-1412]

In Power BI Desktop, I have added this in as a New Column which has gave me the results I am looking for - Forename1:People1 = LOOKUPVALUE('Workforce Profile'[Forename1:People],'Workforce Profile'[Occupancy Reference],'Sickness Absence'[Occupancy Reference]), however if I wanted to write this as a Query in the Advanced Editor to be able to automatically add this New Column in, how would I go about it? 

[v-qiuyu-msft]

Hi @EWilson-1412,

In Query Editor, you can use Merge Queries feature to merge tables Workforce Profile and Sickness Absence  based on 'Workforce Profile'[Occupancy Reference] and 'Sickness Absence'[Occupancy Referenc] column. Then expand new column and choose 'Workforce Profile'[Forename1:People] column. 

See: 

https://www.youtube.com/watch?v=hVWSxX-uF-0

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-data

https://support.office.com/en-us/article/Merge-queries-Power-Query-fd157620-5470-4c0f-b132-7ca2616d1...

Best REgards,
Qiuyun Yu