Tag: Inactive Relationship

Data Modelling In Power BI: Tips & Best Practices

Data Modelling In Power BI: Tips & Best Practices

In this tutorial, you’ll learn valuable tips and best practices for data modelling in Power BI. You can watch the full video of this tutorial at the bottom of this blog. This is one of the four pillars of Power BI report development and is a proven method to develop reports with ease. Honing in

Continue reading

Power BI USERELATIONSHIP vs TREATAS

Power-BI-USERELATIONSHIP-vs-TREATAS

I’m going to show you the difference between the Power BI USERELATIONSHIP function and the TREATAS function that are both used when creating DAX measures. You may watch the full video of this tutorial at the bottom of this blog. I got this tutorial idea from a question that was raised on the Enterprise DNA

Continue reading

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. You may watch the full video of this tutorial at the bottom of this blog. I also want to show you how you

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. You may watch the full video of this tutorial at the bottom of this blog. This discussion is based on a question in the Enterprise DNA support forum. A Power

Continue reading