Tag: Power BI Techniques

How to Maximize The Use of INTERSECT Function – Advanced DAX

The INTERSECT function in Power BI is an advanced table function and you need to understand it better so you can maximize the use of this advanced DAX. But to understand how it works, you need to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within

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. This will be relevant if you don’t actually sell something every day or if you’re looking at a particular customer or a product and

Continue reading

Power BI Reporting Templates Expanded – Power BI Visualization Concepts

In this tutorial, I dive into how to customize Power BI reporting templates efficiently. When you create tables inside Power BI, you can’t format or design them exactly the way you want them to be. You can only use the default order or sequential order that Power BI generates within the table, which can be

Continue reading

Discover Multiple Product Purchases Using DAX in Power BI

We’re going to review a unique customer insight in this example. Specifically, we’re going to understand how to work out the number of customers with multiple product purchases. While this might seem like a relatively logical calculation, there’s actually more to it when using DAX. This is a perfect example of how you can utilize

Continue reading

Showcasing Workday Number in Power BI Using DAX

We’re going to work through something really unique around Time Intelligence inside Power BI. This technique can help you track and determine the exact workday number in Power BI using a variety of DAX formula and advanced logic. Getting around this analysis can help solve an issue around comparing and counting working days in a

Continue reading