Tag: Power BI Advanced DAX Combination

Inventory Management Dashboard In Power BI

Inventory Management Dashboard In Power BI

In this tutorial, you’re going to learn the complex measures and DAX formula used to create an inventory management dashboard in Power BI. As a seller, you have to know how many products you need to re-order and stock and how much these will cost you. Use these DAX formula patterns to get those calculations

Continue reading

Introduction To Advanced DAX in Power BI

In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few

Continue reading

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. In this example, we’re looking at a customer

Continue reading

Power BI Advanced Analytics: Secondary Table Logic Techniques

In this tutorial, I’m going to run through some advanced analytics techniques within Power BI and the DAX formula language that I call secondary table logic. Sometimes when using Power BI for your analytics, you’ll want to find or discover interesting insights, but the current data you’re working with may not allow you to extract

Continue reading

Basket Analysis Example – Power BI Advanced Analytics

In this tutorial, I’m going to run through some of the most advanced types of analytical work you can do with Power BI, and that is Basket Analysis. This theoretical concept has lots of applications across Power BI. What I’m going to go into here is how you can use this type of analysis to

Continue reading