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
In this blog post, I’m going to go over why you need to learn DAX and provide an overview of what it is. I’m going to show you some examples of what we can achieve if we use DAX intelligently in Power BI. Let’s start. Sales Analysis In this example, we have a sales analysis
I want to dive deeply into how useful the COUNTROWS DAX function can be. You could be a newbie who hasn’t fully grasped how COUNTROWS works. You could also be a more experienced Power BI user but are unsure of how you can maximize the function. Through the examples I’ll be giving below, you’ll see
