Excel Magic Trick 1490

DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price

DESCRIPTION

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. Introduction and Setup of Data Model
2. Exact Match Lookup in a DAX Calculated Column using Relationships and the RELATED DAX Function, in Excel Power Pivot
3. Approximate Match Lookup in a DAX Calculated Column using the DAX Functions CALCULATE, MAX and FILTER, in Power BI Desktop
4. DAX Formula in a DAX Calculated Column for correct Volume Discount Product Price, in Excel Power Pivot
5. 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

WORKBOOKS

Download “Excel Magic Trick 1481-1490” Excel-Magic-Trick-1481-1490.zip – Downloaded 38 times – 2 MB







Be the first to comment

Leave a Reply