Tag: SUMMARIZE Function

Calculating Median Value Using DAX In Power BI

By Sam McKay, CFA on June 19, 2020May 11, 2022

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 Power BI

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

By Sam McKay, CFA on March 16, 2020May 16, 2022

CROSSJOIN function, how to use the crossjoin function post image

For this blog post, I want to demonstrate the CROSSJOIN function. I’m going to show an example of how I used it, and then explain when and where you can use it as well. You may watch the full video of this tutorial at the bottom of this blog. CROSSJOIN is a really effective function

Posted in: Advanced DAX, Advanced Power BI, CROSSJOIN Function, DAX Funtions, DAX tutorial, DISTINCT Function, SUMMARIZE Function