This module is a “refresher” on how CALCULATE works for simple filters.
Power BI for the Business Analyst – Advanced Topics covers the more complex concepts of Power BI data modelling, such as ‘Evaluation Contexts’, ‘How using CALCULATE () enables Context Transition’, and ‘Harder to understand patterns such as custom time intelligence’.
Each concept is explained in a video using relevant examples and you have direct access to contact Matt Allington to ask questions about anything that you don’t understand.
It is very common for students learning this topics to require multiple repeat review of the material to understand them well – this makes online video training a perfect medium. This course enables you to go through the lessons at your own pace and at your convenient time until you master the content.
The DAX skills that you learn in Power BI are transferable to Excel. In this course, you get a bonus lesson – Moving from Power BI to Excel.
Evaluation Contexts and Context Transition covers the most complex concepts of Power BI. Each concept is explained with illustrations. These concepts require multiple repeat sessions of study for you to understand and use them.
In this module the advanced concepts of DAX such as Custom Time Intelligence and VAR Syntax are explained.