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 -
1 view
372
93
6 months ago 00:25:31 1
What Happened To Men?
6 months ago 00:03:30 1
The Jewish Refugee who became Saladin’s Doctor | House of Wisdom | E5
6 months ago 00:08:14 1
MOTHER OF DRAGONS COMET DEVOURS THE CHILD JUPITER - PASSOVER, APRIL 21, 2024
6 months ago 00:07:38 1
「戦争のつくりかた」アニメーションプロジェクト-What Happens Before War?-
6 months ago 00:00:51 1
Undertale Purgatory - Papyrus #shorts
6 months ago 00:13:40 1
Cheap and Cool Gadgets Under $50
6 months ago 01:39:07 1
Depeche Mode - Some Great Reward Tour 1984/85 The Complete Tour 21 songs
6 months ago 00:16:29 1
The Glenn Chair Build
6 months ago 00:04:21 1
Bryan Ferry - Don’t Stop The Dance (Art Remastering)
6 months ago 00:08:12 1
💥NEW. Place the sticker tape on the zipper sew. You will thank me for the rest of your life
6 months ago 00:02:38 1
The Mamas & The Papas - California Dreamin’
6 months ago 00:10:56 1
Sunset Melodies # 2 - Progressive House
6 months ago 00:03:05 1
Dune Official Trailer
6 months ago 00:02:46 1
Modern Talking - Last Exit To Brooklyn (Video)
6 months ago 00:03:30 1
British Cross Country Championship - Round 1 - Day 2 - #BXCC
6 months ago 00:03:39 1
VITAS - Звезда (Official video 2003)
6 months ago 01:23:53 1
Stalin, The Red Terror | Full Documentary
6 months ago 02:01:07 1
The Great Outdoors 🏞️ - An Indie/Folk/Pop Nature Playlist
6 months ago 00:01:00 1
Sovol SV08 - First Print Report #3dprinting #livestream #3dprinted
6 months ago 00:02:05 1
OUT NOW - The 7 Savage: 1984-1992 Box Set – 2ND EDITION #wasp #blackielawless
6 months ago 00:04:29 1
Lee Aaron - Even It Up (Official Video)
6 months ago 00:06:01 33
Titanic’s Southampton Departure | Animated 112 Years Later
6 months ago 00:08:46 1
St. Faustina Kowalska - Great Queen OF UK Is In Hell & Her Chilling Revelation Of What Happens There
6 months ago 01:02:56 1
Brotherhood | 1 hour handpan music | Malte Marten & Johann Immanuel