Forum Discussion
Solved
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 fr...
nisha_deepak - Create a column as below-
Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])
nisha_deepak - Create a column as below-
Measure = IF(ISBLANK('TableName'[invoice_date]),'TableName'[policy_expiry_date],'TableName'[invoice_date])
thanks.It helps me to solve my problem