Tag: Inactive Relationship

Power BI Progress Tracker For Sales And Order Data

This tutorial will show how to create a Power BI progress tracker for sales and order data. You’ll learn how to solve a scenario where you have more than one date in your Fact table. This is the Sales table that will be used in this tutorial. You can see that it has two date

Continue reading

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

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