Tag: Virtual Tables Power BI

DAX Table Functions In Power BI

In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical

Continue reading

How To Use The COUNTROWS DAX Function In Virtual Tables

I want to dive deeply into how useful the COUNTROWS DAX function can be. You could be a newbie who hasn’t fully grasped how COUNTROWS works. You could also be a more experienced Power BI user but are unsure of how you can maximize the function. Through the examples I’ll be giving below, you’ll see

Continue reading

Advanced Tips To Optimize Your Power BI Table

This tutorial showcases some advanced tips to optimize your Power BI table. I’ll show you how to break out your large table into multiple ones. This concern is quite common across legal database systems with huge flat files of information. Huge tables need to be broken down into simpler tables for easy information management. Most

Continue reading

Calculating Median Value Using DAX In Power BI

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 –

Continue reading

Creating Power BI Tables By Using UNION & ROW Function

I’m going to show you how you can create Power BI tables using a formula that combines the UNION function and the ROW function. There are many ways to create Power BI tables but in this case, I will show you a powerful technique that can provide you with valuable information and insights. To create

Continue reading