Tag: DAX Measures

Using The ALL Function In Power BI For High Quality Insights

This video tutorial shows you how you can use the ALL Function in Power BI to showcase unique insights. Think about this one from a deeper analytical perspective. We’re going to dive into the average order size for sales we may be making across a variety of different products. If you’re selling to a lot

Continue reading

What You Will Learn During The Next Enterprise DNA Learning Summit

The next learning summit is not far away and we already have well over 1000 Power BI users registered for the event. There is going to be a significant amount to learn about high quality Power BI development so if you haven’t had a chance to register right now then you still can below Enterprise

Continue reading

Dynamic Scenario Analysis of Average Order Size – Analytics with Power BI

In this video tutorial, I’m going to go through something quite practical for a retailer who sells goods at a high frequency. When you are a business that sells a lot of goods – let’s think about an online retailer – if you can analyse how much you would benefit from increasing your average order

Continue reading

Calculate Rolling Totals in Power BI Using DAX

Here I’m going to show you how you can calculate the amount sold between two different dates. Another way to think about this is calculating rolling sales or running totals. We need the calculation to be dynamic, so that as we move through time we have a number that re-calculates based on the time frame

Continue reading

Developing Sensitivity Analysis Logic Using DAX in Power BI

We’re getting specific today and really showcasing the analytical power of Power BI. Sensitivity analysis, or even running some ‘what ifs’ around this, allows you to almost predict what may happen in the future with your results. In this example I want to see what will happen to my profitability if I am able to

Continue reading