Showing results for 
Search instead for 
Did you mean: 
EWilson-1412 New Member
New Member

Vlookup and Power BI Advanced Editor

In Power BI Desktop, I have added this in as a New Column which has gave me the results I am looking for - Forename1Smiley Tongueeople1 = LOOKUPVALUE('Workforce Profile'[Forename1Smiley Tongueeople],'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? 

Moderator v-qiuyu-msft

Re: Vlookup and Power BI Advanced Editor

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'[Forename1Smiley Tongueeople] column. 





Best REgards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.