Tag: Inactive Relationship

Active And Inactive Data Relationships In Power BI

Active And Inactive Data Relationships

Previously, I discussed the importance of data model relationships in Power BI. I also introduced the one-to-many and many-to-one relationships. Now, I’ll teach you about the difference between active and inactive data relationships. These are important concepts that you need to be familiar with in data modelling. In this example, you can see that the

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

How Many Staff Do We Currently Have – Multiple Dates Logic In Power BI Using DAX

In this tutorial, you’ll learn how to work out the current staff population for multiple dates in Power BI using the COUNTROWS and FILTER function. This discussion is based on a question in the Enterprise DNA support forum. A Power BI user wanted to calculate the number of staff members that have been hired within

Continue reading

How To Calculate Occupancy Days Per Month In Power BI Using DAX

This tutorial highlights how we’re able to calculate occupancy days using DAX in Power BI. This is quite helpful for organizations like hospitals, Airbnb, hotels, etc. This is an interesting insight if you want to dive into managing your occupancy levels effectively. This topic came through the Enterprise DNA support forum that I think deserves

Continue reading

How To Work With Multiple Dates In Power BI

As soon as you start developing a few Power BI models, you’ll very likely run into a problem where you have two dates in your fact table and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date, invoiced date, shipped

Continue reading