Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

A. BoxUp and Running with DAX for Power BI https://doi.org/10.1007/978-1-4842-8188-8_10

10. Empty Values vs. Zero

Alison Box¹  

(1)

Billingshurst, West Sussex, UK

 

In this chapter, we will look at a very specific DAX behavior, and that is how DAX treats empty, missing, and null values.¹

Note

We will be examining this behavior in the context of a calculated column and mostly creating expressions that would only be valid in this context. However, you must appreciate that the behavior of empty, missing, and null values is exactly the same in the context of DAX measures, and the examples at the end of this chapter will illustrate this.

The BLANK( ) Function

In DAX, ...