how to specify specific values for blank and non blank cells

[hperashmi83]

Hi All

I am a beginer to PBI and need urgent help on below query.

I have a column with dates when we received bank statement and blank if we dont receive bank statement. I need a measure or a formula which can help me specify a variable.

result expected = cells having dates - "statement received" and blank cells - "statement not received"

Account #	statement date	Required result
2	13/01/2022	statement received
5	13/01/2022	statement received
8	13/01/2022	statement received
6		statement not received
42	18/01/2022	statement received
12		statement not received
31	18/01/2022	statement received
56		statement not received
22	19/01/2022	statement received

[BA_Pete · Accepted solution]

Hi @hperashmi83 

In Power Query - new custom column:

if [statement date] <> null then "Statement received" else "Statement not received"

In DAX - Measure or Calculated Column:

_statementRecvdStatusText =
IF(
  NOT ISBLANK(yourTable[statement date]),
  "Statement received",
  "Statement not received"
)

Pete