For today’s video, we’re releasing the 2nd part of the topic we featured last Wednesday. This was supposed to be published next week but we were surprised with the response on the first video that we decided to bump up the release a bit earlier. I’d like to continue exploring the dynamic uses of the function COLUMNSTATISTICS() – a new, almost entirely undocumented DAX function added to Power BI in August 2021 that has some very unique aspects that I think will be very interesting to get familiar with.
Brian
***** Video Details *****
00:00 Introduction
00:54 COLUMNSTATISTICS() function
01:31 Smart narrative
01:51 Data model
03:20 Transforming data
03:38 List.Dates
05:36 Tabular Editor 3
07:00 Debugging
10:29 Max cardinality
12:40 TOPN
15:10 Additional measures
***** Related Links *****
The Great New Hidden DAX Function Pt. 1 – https://youtu.be/5R_ZqAPzUdA
***** 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 #COLUMNSTATISTIC