The Great New Hidden DAX Function Pt. 1 – Overview

This video walks through COLUMNSTATISTICS() - a new, almost entirely undocumented DAX function added to Power BI in August 2021. This function can be used to quickly create metadata on every table in your data model, including a list of fields, and min, max, max length, and number of unique values (cardinality) for each field. However, there are some very unique aspects to how this function can and can’t be used, which I also go through in this video. Brian ***** Video Details ***** 00:00 Introduction 00:48 COLUMNSTATISTICS description 02:09 Data model 02:26 Physical calculated table 03:12 Circular dependency 03:43 Calculated virtual table 04:44 Card visual 05:08 Extracting data 06:58 Transform data 09:40 Discrepancy ***** Related Links ***** SQLBI DAX Guide Reference - Enterprise DNA Practice Dataset External Tool - ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI -