Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Excel Files: Start: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1492Start.xlsx Finished: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1492Finished.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm 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 https://www.youtube.com/watch?v=oNasRFXagT0 Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks https://www.youtube.com/watch?v=Ex4MGw-VMWc DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490) https://www.youtube.com/watch?v=JHh7BtRugL8