Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
Download Files: Excel Start: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1490Start.xlsx Excel Finished: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1490Finished.xlsx Power BI Start: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1490Start.pbix Power BI Finished: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1490Finished.pbix Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video learn how to create a DAX Calculated Column for Exact Match Lookup and Approximate Match Lookup. See how to combine the two lookups in a formula to lookup the correct Volume Discount Product Price. See how to create these DAX Calculated Columns in both Excel Power Pivot and in Power BI Desktop Topics in this video: 1. (00:01) Introduction and Setup of Data Model 2. (02:49) Exact Match Lookup in a DAX Calculated Column using Relationships and the RELATED DAX Function, in Excel Power Pivot 3. (06:48) Approximate Match Lookup in a DAX Calculated Column using the DAX Functions CALCULATE, MAX and FILTER, in Power BI Desktop 4. (13:16) DAX Formula in a DAX Calculated Column for correct Volume Discount Product Price, in Excel Power Pivot 5. (15:31) DAX Formula in a DAX Calculated Column for correct Volume Discount Product Price using both Exact Match Lookup and Approximate Match Lookup, in Power BI Desktop 6. Summary Excel Magic Trick 1490 Also see: Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks, https://www.youtube.com/watch?v=Ex4MGw-VMWc&t=281s @ 4:19 minute mark