Lookup Values in the Same Table with Power Query M
Do you want to filter your dataset on one column but return a value from a different column? This video shows you two approaches how. The second one is my favorite, but a bit trickier!
CONTENTS
00:00 Introduction
00:39 Data
01:09 Method 1
03:05 Method 2
Master Functions and Syntax in M
https://powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#Lookup #powerquery #bigorilla