DAX is a powerful formula language used in Power BI to create measures which enhance your reporting and analysis.
This hands-on masterclass will provide an overview of how to build measures, using a range of DAX functions. You will learn how to use FILTER functions such as CALCULATE and build a Date Table so you can use Time-Intelligence functions on your financial data
Content
- Understand the difference between calculated columns and measures: Create measures on-the-fly to use in any visual on your report
- Explore the DAX Function Library: Work with some of the most common and useful functions such as CALCULATE, ALL and ALLSELECTED
- Use Time Intelligence in Power BI: Learn how to create a Date Table for your report and build visuals using Time Intelligence functions
Target Audience
This masterclass is designed for anyone wanting to build more dynamic and effective reports and dashboards using DAX. No prior knowledge of DAX is required, though a basic understanding of Power BI Desktop will helpful.
