Tag: Power BI Iterating Functions

Calculating Median Value Using DAX In Power BI

By Sam McKay, CFA on June 19, 2020June 8, 2020

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 –

Posted in: Iterating Functions Power BI, Median Value, MEDIANX Power BI, Power BI Iterating Functions, Statistical Analysis DAX, Statistical Analysis Power BI, SUMMARIZE Function, Virtual Tables Power BI

DAX Financial Reporting Power BI

Using Iterating Functions SUMX And AVERAGEX In Power BI

By Sam McKay, CFA on December 2, 2019January 23, 2020

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

Posted in: AVERAGEX, AVERAGEX Power BI, Iterating Functions, Power BI Iterating Functions, Power BI SUMX Function, SUMX, SUMX DAX