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 – https://dax.guide/columnstatistics/
Enterprise DNA Practice Dataset External Tool – https://youtu.be/szBJSP5d2AA

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial