VLOOKUP Approximate Match in Power Query: Binning & Column by Example
Power Query is fantastic, but there's an ongoing need to do the equivalent of an approximate match like we do when we use VLOOKUP-True to assign categories to values.
This video shows how to assign values by "binning" which is done by using Column by Example and getting help from Power Query. Power Query will build a formula based on how we train it. Once the formula is built, it'll probably be wrong. HOWEVER! It's so much easier to modify the formula than it would be to stack up conditions in a conditional column, or write a messy IF statement in Power Query's M-Code.
This example is good if your categories don't change. If you do need variable tiers/categories, it's better to use the method shown in this video: • VLOOKUP-True Equivalent in Power Quer...
#ColumnByExample
#PowerQueryVLOOKUP
#VLOOKUP
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/ins...
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2