|Equivalent of VLOOKUP in DAX|
|Written by Laurent Couartou|
|Tuesday, 19 February 2013 20:08|
One frequent DAX requirement is to write a formula that behaves like the VLOOKUP function in Excel.
Gehrard Brueckl recently blogged about how to map a date to a fiscal period, when fiscal periods are defined in a separate table, and each period is defined by its start date. Ken Puls recently wrote an article about calculating an effective tax rate with DAX.