Skip to main content
HomeCode alongsData Analysis

Calculating KPIs with DAX in Power BI

Learn to use DAX in Power BI to customize and optimize your KPIs
Feb 2023
View Dataset

Key Performance Indicators (KPIs) allow the business to quantifiably measure the performance of a specific objective over time. They are essential to measure your success! In this live training, you'll get shown how you can use DAX in Power BI to customize and optimize your KPIs for even better performance analysis.

The dataset that will be used in the live training is a Superstore retail sales dataset, which contains different key variables and metrics related to a retail industry company.

Learning by doing is encouraged, so to follow along on your own machine, please download and install Power BI Desktop before this session. If you need help, read the Power BI Install Guide.


Key Takeaways:

  • Using DAX to create sales KPIs and comparing metrics

  • Using time intelligence functions to create KPI calculations

  • Selecting the most appropriate visualizations for your KPIs


Learn Topics Related to This Code Along

Live Training: Exploring World Cup Data in Power BI

We'll use custom visualizations for data analysis and DAX for data manipulation


Live Training: Solving an HR Analytics Case Study with Power BI

Import, analyze and build your very own data model in Power BI Desktop.


Become a Data Analyst with Power BI

Discover the power of Power BI and prepare for Microsoft's official PL-300 exam.