Tag: DAX Functions

What Is DAX? Understanding Its Meaning, Importance And Use

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

Continue reading

Staff Turnover Calculation In Power BI Using DAX – HR Insights

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

Continue reading

Format Currencies In Power BI Using DAX

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

Continue reading

Why You Need To Learn Dax – A DAX Overview

What Is DAX And Why Do You Need To Learn It

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

Continue reading

How To Use The COUNTROWS DAX Function In Virtual Tables

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

Continue reading