In this tutorial, you’ll learn valuable tips and best practices for data modelling in Power BI. You may 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 your
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
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
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
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
