Category: Data Modeling

Analyze Who Your Lost Customers Are Using Power BI & DAX

Use CALCULATE table function to determine the lost customers

In this example we’re going to dive into some customer churn analysis in Power BI. Power BI is an amazing tool for high-quality analytics. It does not have a close competitor at this point in time in my view. In this particular example, I’m going to show you how we can not only work out

Continue reading

Show Results Up To Current Date Or A Specific Date In Power BI

In this tutorial, I’m going to show you a very simple technique where you can show data up to a specific date or just up to today inside of your Power BI reports. This came from a recently requested question from the Enterprise DNA Support Forum, Personally, I’ve also used this technique many times so

Continue reading

Unpivot and Pivot Basics in Power BI – Query Editor Review

There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature within your data queries. One thing to bear in mind early on when working on

Continue reading

How To Create Virtual Relationships Using TREATAS In Power BI

How To Create Virtual Relationships Using TREATAS In Power BI

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside of your Power BI models. It’s only been around for the last couple of years and it has a very specific usage which can become very beneficial if you are looking to simplify your data model and

Continue reading

Show Days Before Or After A Selected Date Using Power BI

Show Days Before Or After A Selected Date Using Power BI

As we work through this tutorial I will show you some truly powerful analytics that you can complete inside of Power BI. It is amazing how flexible you can make your solutions in Power BI if you get the set up right. When I say set up, I mean your data model first and foremost

Continue reading