Excel Magic Trick 1492

DAX Approximate Match Lookup

DESCRIPTION

In this video learn how to do Approximate Match Lookup in a DAX Calculated Column using two different methods.

Topics:

1. Introduction & look back to last video where we used MAX Function on Discount Column

2. DAX LOOKUPVALUE Function, DAX Approximate Match Lookup

3. Foreign Key, Relationship & RELATED Function, DAX Approximate Match Lookup

4. Summary

WORKBOOKS

Download “Excel Magic Trick 1491-1500” Excel-Magic-Trick-1491-1500.zip – Downloaded 166 times – 10 MB







Be the first to comment

Leave a Reply