Download Excel File: https://ift.tt/2rtY5bv
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to do Approximate Match Lookup in a DAX Calculated Column using two different methods. These tricks come from out YouTube Teammates: Geert Delmulle @ YouTube and RRR program @ YouTube.
Topics:
1. (00:01) Introduction & look back to last video where we used MAX Function on Discount Column
2. (04:50) DAX LOOKUPVALUE Function, DAX Approximate Match Lookup
3. (10:41) Foreign Key, Relationship & RELATED Function, DAX Approximate Match Lookup
4. (12:26) Summary
Other Videos about Approximate Match Lookup in DAX:
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks
DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490)
https://www.youtube.com/watch?v=JHh7BtRugL8