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
Tag: Advanced analytics
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
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
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
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