Equivalent of VLOOKUP in DAX
User Rating: / 0
PoorBest 
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.

Read more Part 1...

Read more Part 2... 

 

Tags: dax, tabular
 

Pyramid Analytics