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
In this example, I will show you how you can create a reverse cumulative total inside of Power BI using DAX. This question came up recently on the Enterprise DNA Support Forum. You can view this forum post here – Reverse Cumulative Sum A member had a unique requirement where they needed a cumulative total from
Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking. This is a really powerful technique that you can utilize in Power BI. Never think you are limited to the standard ‘out of the
As soon as you start developing a few Power BI models, you’ll very likely run into this problem … You have two dates in your fact table (your transaction 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,
One thing that can seem like a limitation of Power BI is its calendar date table. Often, you’ll need to calculate results across a custom financial year, but only the standard date table is available. You may initially think that you need a new date table, but you don’t. You can use DAX in either
