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
Many times with the analytical work that you are completing, you may want to showcase anomalies. The reason for doing this type of analysis is that you will sometimes want to understand why you’re receiving some type of outlier or anomaly in your data set. Additionally, you want to be able to narrow your focus into
