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. So before you dip your head in working with complex calculations, I will share with you some simple iterating functions in this article. Why Use Iterating Functions? I get this question all the time as I do live
