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
Tag: Virtual Tables Power BI
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. You may watch the full video of this tutorial
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. You may watch the full video of this tutorial at the bottom of this blog.
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 –
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. You may watch the full video of this tutorial at the bottom of this blog. There are many ways to create Power BI tables but in this case, I will show