Forum Discussion
Check date column is empty when creating a measure
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.
nisha_deepak - Create a column as below-
Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])
4 Replies
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])))
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?
nisha_deepak - Create a column as below-
Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])
