Report Portal

Equivalent of VLOOKUP in DAX

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


2007-2015 VidasSoft Systems Inc.