Tag: Advanced analytics

How To Calculate Difference In Days Between Purchases Using DAX In Power BI

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. You may watch the full video of this

Continue reading

Comparing Any Sale Versus The Last Sale (No Time Intelligence) – Advanced DAX In Power BI

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. You may watch the full video of this tutorial at the bottom of this blog. This will be relevant if you don’t actually sell

Continue reading

How To Use SWITCH True Logic In Power BI

When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. You may watch the full video of this tutorial at the bottom of this blog. In this tutorial, I’ll run through how you need to set up your formulas when using the SWITCH function. This will enable

Continue reading

Analyze Profit Margin Changes Overtime – Analytics with Power BI and DAX

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. You may watch the full video of this tutorial at the bottom of

Continue reading

Forecasting Product Demand Using Power BI Analysis Techniques

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. You may watch the full video of this tutorial at the bottom of this blog. Power BI is an amazing tool for data analysis when you

Continue reading