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
I wanted to highlight in this post some of my best practice tips when organizing detailed Power BI models. You’ll find as you work through any development, elements of your Power BI reports will grow. This can be things like new tables of data, differing relationships between tables, an assortment of measure groups and much
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
In this unique example, I want to show you how you can take a historical trend and repeatedly project it forward. This particular example came to me from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world. They had to take historical
I wanted to be able to drill into a specific subset of my customers – in this particular case – I decided to delve into the top 20% as it was most relevant to my analysis, and follows on from a previous tutorial about the Pareto principle – also known as the 80/20 rule. Not
