Category: DAX

Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days

Sometimes when analyzing your Power BI reports, you may want to know how many transactions have occurred over a particular period of time. In this blog post, I’ll show you exactly how to calculate transactions within a given period of days using time intelligence in Power BI.  This post will cover a high quality piece

Continue reading

Using The ALL Function In Power BI For High Quality Insights

This blog post will show you how to use the ALL function in Power BI to effectively showcase unique insights and differentials in your numbers. We’re going to dive into the average order size for the sales we may be making across a variety of different products. This tutorial will also show you how to

Continue reading

Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX

In this blog post, I’m going to show you how you can create a new table in Power BI that is purely based on historical information and complete it in an automatic way. When you create budgets and forecasts sometimes you may have to go through a very comprehensive process. I’m going to showcase a

Continue reading

Use DAX To Segment & Group Data In Power BI

Using DAX measures to dynamically group data in Power BI is so powerful. You’re building out your data models and creating many different filters and ways to slice your data. This is slightly more advanced today, but I love this type of stuff in Power BI. Remember, these likely don’t exist in your original datasets,

Continue reading

Using Dynamic Visuals On Ranking Based Parameters In Power BI

Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking in Power BI. We’re going to create dynamic visuals containing our top 10 customers for specific products. This is a really powerful technique that

Continue reading