I’m going to share a quick and efficient formula around the DAX MAXX function in Power BI. In this example calculation, I’ll show you how to find the last date something occurred using MAXX, which is an iterating function. You may watch the full video of this tutorial at the bottom of this blog. I’ve
This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This
In this tutorial, I show you how to calculate the median value from a list of values inside Power BI using the MEDIANX function together with other DAX functions. I demonstrate how you can place a virtual table inside of this function, and then evaluate through that virtual table to obtain the ultimate result –
One of the most crucial topics for any Power BI beginner to know about is iterating functions. You may watch the full video of this tutorial at the bottom of this blog. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article.
