ISBLANK

In the Ultra Transcenders books

DP-600

Each book explains ISBLANK in context, with comparison tables and the common traps.

Terms in this definition

• DAX

  Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.

• BLANK

  DAX uses BLANK to mean no value at all. It resembles NULL in SQL but behaves more like an empty cell in Excel, so adding 20 to it returns 20; the BLANK function creates one and ISBLANK detects it.

• NULL

  Marks that a row has nothing in a particular column, as when a person has no middle name. Columns defined NOT NULL can never be left empty.

• Serverless

  Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.

Related terms

• Information functions

  ISBLANK, ISFILTERED, ISCROSSFILTERED, ISINSCOPE and HASONEVALUE all belong to this DAX family, whose members inspect a value or check what filters currently apply.

• Power Fx

  Low-code formula language, similar to Excel, used in Foundry workflows. Each variable takes a Local. or System. scope prefix; IsBlank checks a value, IsEmpty checks a table and Upper() converts text to capitals.