Tag: Power BI Table Functions

New DAX Function COLUMNSTATISTICS – Overview

This tutorial will walk you through COLUMNSTATISTICS() – a new DAX function, which is almost entirely undocumented. It has been added to Power BI in August 2021. You can watch the full video of this tutorial at the bottom of this blog. This function can be used to quickly create metadata on every table in

Continue reading

Tables In Power BI: Types & Distinctions

Tables In Power BI- Types & Distinctions

I want to spend some time today talking about tables in Power BI. We run into tables all the time with every problem, but we don’t really spend a lot of time thinking about them alone. You can watch the full video of this tutorial at the bottom of this blog. There was a post

Continue reading

Power BI DAX ALL Function – How It Works

Power-BI-DAX-ALL-Function-–-How-It-Works

I want to give you a really quick introduction to the Power BI DAX ALL function. I find that there can be a bit of confusion around how this function works, and I want to simplify it and make it easy to understand. This tutorial will enable you to recognize where and when you should

Continue reading

Using DAX Table Functions In Power BI

I want to introduce you to a group of functions in Power BI called table functions. These functions include FILTER and ALL which we already used or mentioned in other topics. There is a whole range of other table functions which includes functions like VALUES, TOPN, and ADDCOLUMNS. However, we are not going to cover

Continue reading