Tag: Advanced Power BI

Understanding How The AVERAGEX Function Works

In this example, we’ll dive deep into the AVERAGEX function. This is a truly powerful function that can be used in so many different ways. It can very efficiently calculate interesting results very quickly. You need to truly understand how this works and what’s happening behind the scenes. That’s what this tutorial is focussed on.

Continue reading

Compare One Sale Versus The Last Sale (No Time Intelligence)

In this unique example, I will show you how you can 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 single day or if you are looking at a particular customer or a product and you want to

Continue reading

Understanding LASTNONBLANK For Use In Power BI

The LASTNONBLANK function is an interesting DAX formula that you can utilize in a number of different ways inside of Power BI. It is not a very used DAX formula because of the complexities around how it calculates results. Most Power BI users, I would presume, don’t even realize that they can utilize the function

Continue reading

How To Use The CROSSJOIN Function – Power BI & DAX Tutorial

CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data together. It’s not just about selecting any two tables from your data sets. What you can do is actually also manipulate tables inside of the CROSSJOIN function so they can be joined in a

Continue reading

Deep Dive Into ALLSELECTED – DAX Function In Power BI

The ALLSELECTED function inside of Power BI is a complex DAX function. It is one of the more advanced functions that you can utilize within your reports and dashboards. In my view, it is one that you have to learn well. You can’t just forget about it and not focus on ways you can utilize

Continue reading