How to handle Blanks and Nulls in Power BI

on YouTube ↗20m

" summary

Power Query treats nulls as unknown so any arithmetic or concatenation with them returns null unless replaced early in the ETL (recommend handling in the silver layer or using double question mark coalesce or null-aware functions). The semantic model (DAX) treats missing values as blanks that convert to 0/""/date 1899-12-30/false unless tested with strictly equal (==). Referential-integrity gaps add a blank row in dimension that VALUES, ALL and SUMMARIZECOLUMNS reveal; replacing blanks in DAX can break performance during context transitions.

AI-written summary · about

" chapters (5)

1. 0:00Handling blanks and nulls
2. 1:57Nulls in Power Query
3. 8:26Semantic model with DAX
4. 16:51Blank row propagation in DAX
5. 19:20Summary & Q&A

" related talks

• 51mData modeling for experts with Power BIMarc Lelijveld, Jeroen ter Heerdt · SQLBits 2023
• 28mPower BI PointersPriscilla Camp · Power Platform Virtual Conference 2021
• 51mPower BI Composite and Hybrid ModelsAlex Whittles · SQLBits 2023
• 50mTime Intelligence in Power BIAlberto Ferrari · SQLBits 2023
• 48mTime Intelligence in Power BIThomas LeBlanc · Power Platform Virtual Conference 2021
• 01h 08mAdvanced Modelling and Calculation Using the Power BI DesignerKasper de Jonge · PASS Business Analytics Conference 2015
• 43mBecome a Power BI Data Modeling Wizard using Tabular Editor 3Morten Lønskov, David L. Bojsen · SQLBits 2023
• 50mThe Path to Success with Power BI: Best PracticesPatrick LeBlanc, Adam Saxton · SQLBits 2023