You’ll learn in this tutorial how to calculate difference in days between purchases using DAX in Power BI. This topic came from the Enterprise DNA support forum and I’ll show you how I solved it. This is an interesting scenario and quite common in the business world. In this example, we’re looking at a customer
In this unique example, I’ll show you an advanced DAX technique in Power BI wherein we compare a sale on any particular day to the very last sale that was made. This will be relevant if you don’t actually sell something every day or if you’re looking at a particular customer or a product and
When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. In this tutorial, I’ll run through how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights within Power BI. There
In this blog post, I will show a really unique and specific example where I’m going to hone in on how you can combine lots of the techniques that I’ve described in many previous tutorials to come up with profit margin changes. These are techniques like Measure Branching, Trend Analysis, and DAX Formula Combinations. What
In this tutorial I run through some great scenario analysis techniques and demonstrate how you can combine several of them in Power BI. I’m talking about forecasting product demand. Power BI is an amazing tool for data analysis when you can implement techniques like this one. Take a situation where you want to analyze future
