IFBLANK function

Metric to Fill

(required)

Any

Any Dimensions

First source Block that contains some blank cells.

Value

(required)

Same Type as Metric to Fill

No Dimension or Dimensions of Metric to Fill

Number, formula or second source Block to fill the blanks with.

Same Type as Metric to Fill

Dimensions of Metric to Fill

IFBLANK(List.Dates1, List.Dates2)

Overwrites current column with values from the property List.Dates1. Any blanks are filled by List.Dates2 where it has data.

This is a convenient way to tidy up imports into Transaction Lists.

IFBLANK(List.Dates1, IFBLANK(List.Dates2,List.Dates3))

Nested IFBLANK expressions overwrite current column with values from the property List.Dates1. Any blanks are filled by List.Dates2 then by List.Dates3 where they have data.

This merges three columns into one, respecting a hierarchy.

IFBLANK(SOURCE_METRIC, 20)

Returns a Metric full of SOURCE_METRIC data and 20s.

Filling the current Metric in this way is convenient but makes it high density, which can slow down performance. Coupling with IF() expressions can remediate this.

IFBLANK(SOURCE_METRIC, PREVIOUS(MONTH))

Returns a Metric full of SOURCE_METRIC data, with any BLANKS filled with data from the previous month.

As above, convenient but if you encounter performance issues, combine with IF() expressions.