Here I dive into the AVERAGEX function. By learning and understanding how to use this function, you very quickly open up a range of analysis that can be incredibly insightful and valuable. Maybe you want to work out the average sales you make per day, per month, per customer, per day, and so on. There
The ALL function is an extremely important part of the DAX language in Power BI. It can be used in a number of different ways within formulas that allow you to calculate results seamlessly when combined with the filtering available in the data model. Simply put, the ALL function can remove any context that is
In this unique example, I want to show you how you can take a historical trend and repeatedly project it forward. This particular example came to me from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world. They had to take historical
The INTERSECT function in Power BI is an advanced table function and to understand how it works, you will want to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within Power BI. What the INTERSECT function does specifically is that it allows you to – within a
I wanted to be able to drill into a specific subset of my customers – in this particular case – I decided to delve into the top 20% as it was most relevant to my analysis, and follows on from a previous tutorial about the Pareto principle – also known as the 80/20 rule. Not
