In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few
This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This
Once you understand transformations and data modeling, you can finally start working on visualizations on your reports. This would require a deeper understanding of DAX. What Is DAX? What is DAX and why is it important? DAX stands for Data Analysis Expressions. DAX is the formula language within Power BI. This is where Power BI’s
I’m going to do a quick review of how staff turnover calculation is done. This will show you how to check the number of staff you have at any point in time. I also want to show you how you can compare how many people are getting onboard versus how many people you’re losing. This
This tutorial will focus on currency conversions and how to format these converted currencies using DAX in Power BI. In this example, Sales will be used to run a report based on different currencies from World Wide Importer’s data. Assumptions Used These are the assumptions that you should remember in this remodelling: Creating The Currency
