Check date column is empty when creating a measure

[nisha_deepak]

I have a column named invoice_date which is of type date .Some times in invoice_date value will be empty.So, i want to create measure by  check whether that value is empty means i want add a value from another column (Policy_expiry_date) which is of type date else i have to take value from invoice_date itself.Plse help me.

[amitchandak]

@nisha_deepak , Nor very clear

check blank

calculate(count(Table[Policy_expiry_date]), isblank(Table[invoice_date]))

check not blank

calculate(count(Table[Policy_expiry_date]), not(isblank(Table[invoice_date])))

[nisha_deepak]

checking invoice_date is empty or not ,if empty means take value from policy_expiry_date,

then put it in measure column.Is it possible.plse help me?

[Anonymous · Accepted solution]

@nisha_deepak - Create a column as below-

Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])

[nisha_deepak]

thanks.It helps me to solve my problem