Beskrivning

There are millions of Microsoft Excel users who are familiar with using Excel formulas to perform calculations. Those calculations may be as simple as adding up a column of numbers, or they may be far more complex simulations of various business models. But in every case, each formula is built using a combination of basic operators and functions that are provided within Excel. Similarly, for professional BI solution developers using Multidimensional Expressions (MDX) in multidimensional model solutions, the fundamental concepts of creating calculations by using formulas is much the same; however, the differences in syntax, operators, and functions between MDX and DAX formulas is greater than it is between Excel and DAX formulas.

Whether you are familiar with Excel or MDX formulas, this basic understanding of formulas is important when developing tabular data modeling solutions. While understanding Excel or MDX formulas will give you a head start in learning DAX, it is not necessary.

DAX formulas are very similar to Excel formulas, and there is considerable overlap between the list of DAX functions and Excel functions. But there are also significant differences, and many new functions in DAX that don’t exist within Excel. These functions are designed to offer capabilities that focus on data analysis, particularly for related tables of data, and for dynamic analysis.

Prerequisites
Knowledge of how to create content using Power BI Desktop.
Knowledge of how writing formulas in Excel.

Kursen levereras i samarbete med

Kontakta oss om denna kurs