Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1137.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to 1) (00:08 min) Intro. 2) (01:21 min) Approximate Match with VLOOKUP. 3) (02:20 min) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula). 4) (05:11 min) Approximate Match Lookup in PowerPivot DAX using CALCULATE, MAX, FILTER and Boolean Logic.