Excel Magic Trick 1137

Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP

DESCRIPTION

See how to
(00:08) Intro.
(01:21) Approximate Match with VLOOKUP.
(02:20) Approximate Match with AGGREGATE (to simulate logic that is present in DAX formula).
(05:11) Approximate Match Lookup in PowerPivot DAX using CALCULATE, MAX, FILTER and Boolean Logic.

WORKBOOKS




Be the first to comment

Leave a Reply