This comprehensive and authoritative guide will teach you the dax language for business intelligence‎,‎ data modeling‎,‎ and analytics‎.‎ Leading microsoft bi consultants marco russo and alberto ferrari help you master everything from table functions through advanced code and model optimization‎.‎ You‎'‎ll learn exactly what happens under the hood when you run a dax expression‎,‎ how dax behaves differently from other languages‎,‎ and how to use this knowledge to write fast‎,‎ robust code‎.‎ If you want to leverage all of dax‎'‎s remarkable power and flexibility‎,‎ this no‎-compromise ‎"‎Deep dive‎"‎ is exactly what you need‎.‎ Perform powerful data analysis with dax for microsoft sql server analysis services‎,‎ excel‎,‎ and power bi * master core dax concepts‎,‎ including calculated columns‎,‎ measures‎,‎ and error handling* understand evaluation contexts and the calculate and calculatetable functions* perform time‎-based calculations‎:‎ ytd‎,‎ mtd‎,‎ previous year‎,‎ working days‎,‎ and more* work with expanded tables‎,‎ complex functions‎,‎ and elaborate dax expressions* perform calculations over hierarchies‎,‎ including parent/child hierarchies* use dax to express diverse and unusual relationships* measure dax query performance with sql server profiler and dax studio