Download Files:
Excel Start: https://ift.tt/2HT3MKp
Excel Finished: https://ift.tt/2rnmBuf
Power BI Start: https://ift.tt/2HQRnGK
Power BI Finished: https://ift.tt/2rodppn
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
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