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.