cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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? 

1 REPLY 1
Highlighted
Moderator v-qiuyu-msft
Moderator

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. 

 

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 

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.