22-25 April 2026 
SQLBits 2024
How to handle Blanks and Nulls in Power BI
This session delves into managing missing data in Power BI, starting with the challenges posed by null values in Power Query and progressing to the concept of blank propagation in DAX, which is crucial for engine optimization. It will cover strategies for handling null values, understanding the impact of blanks in DAX expressions, and addressing blanks arising from referential integrity issues. Participants will learn to adeptly navigate and resolve issues related to missing values in Power BI.
Join us for a session where we dive deep into the world of missing data in your Power BI projects.
To kick things off, we'll address the potential pitfalls of null values in Power Query transformations and explore effective techniques to steer clear of these challenges.
Next, we'll delve into the realm of blank propagation within the DAX Language. Discover why it holds paramount importance for engine optimizations and gain a clear understanding of how it translates when used within an expression.
In the final segment, we'll tackle the issue of blank generation originated from referential integrity violations and how to resolve this common concern.
By the end of this session, you'll be well-equipped to handle missing values with confidence and finesse in Power BI.
To kick things off, we'll address the potential pitfalls of null values in Power Query transformations and explore effective techniques to steer clear of these challenges.
Next, we'll delve into the realm of blank propagation within the DAX Language. Discover why it holds paramount importance for engine optimizations and gain a clear understanding of how it translates when used within an expression.
In the final segment, we'll tackle the issue of blank generation originated from referential integrity violations and how to resolve this common concern.
By the end of this session, you'll be well-equipped to handle missing values with confidence and finesse in Power BI.
Speakers
Renato Lira's previous sessions
How to handle Blanks and Nulls in Power BI
This session delves into managing missing data in Power BI, starting with the challenges posed by null values in Power Query and progressing to the concept of blank propagation in DAX, which is crucial for engine optimization. It will cover strategies for handling null values, understanding the impact of blanks in DAX expressions, and addressing blanks arising from referential integrity issues. Participants will learn to adeptly navigate and resolve issues related to missing values in Power BI.
Demystifying Power BI Variables: A Comprehensive Guide to Understanding DAX and M Variables
This session is a deep dive into the use of variables within DAX and Power Query M for developing complex logic in Power BI solutions. It begins with an exploration of the Queries pane as the base for variable creation in M, using the "let" and "in" operators, then examines the use of both global and local variables in DAX, emphasizing their nature as constants. Common use cases and potential pitfalls will be discussed, along with the concept of precedence in variable usage across multiple scopes. Attendees will gain a nuanced understanding of variable application in the two main engines of Power BI.
DAX Visual Calculations: What You Need to Know
Join us for a deep dive into DAX Visuals Calculations.
Learn why "Regular DAX" struggles with basic calculations like running sum or moving average and everything you should know to take advantage of visual calcs.