Sometimes when analyzing your Power BI reports, you may want to know how many transactions have occurred over a particular period of time. In this blog post, I’ll show you exactly how to calculate transactions within a given period of days using time intelligence in Power BI. This post will cover a high quality piece
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
In this tutorial, we’re going to do a deep dive into the cumulative total formula combination that can be used in Power BI. Cumulative totals are a great way of showing trends over time and then also showcasing differences in trends between different timeframes. There is a common combination of DAX functions to use that
With Basket Analysis, what we’re trying to achieve is analyzing one grouping of products versus another grouping of products. There’s plenty of application for this across Power BI. The theory we’re trying to work through with this type of analysis is if one grouping of products is bought with another grouping of products. By running
