From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

BLANK and ISBLANK DAX functions

BLANK and ISBLANK DAX functions - Power BI Tutorial

From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Start my 1-month free trial Buy for my team

BLANK and ISBLANK DAX functions

“

- [Instructor] There are several DAX functions that let us build formulas to manage blanks. Two of these functions are BLANK, which returns a measure result as a null value, and ISBLANK, which is a logical function that returns a Boolean result. In Power BI, let's explore how the BLANK function works. Let's select the loan period measure and comment out the existing formula with two forward slashes. Let's first set this measure equal to BLANK, which doesn't have any input parameters inside its parentheses. The entire column is now empty, which might perhaps imply that the BLANK function returns an empty text label. But BLANK really returns a null and how this works can be a bit confusing at first. Let's update our existing measure to combine it with the word hello using an ampersand as the connector. Now let's change the formula so we had a one to the BLANK function instead. Now we see the BLANK function operates…

Contents