if(isblank
2 Topics
Making empty row in a date column as pending
Thanks in advance for helping me with this challenge here I'm trying to indentify empty row as pending. this the DAX code I wrote Status = IF('Fact-Tasks'[Closed] = BLANK(), "Pending",'Fact-Tasks'[Closed]) but I get this error "Expressions that yield variant data-type cannot be used to define calculated columns"Solved635Views0likes2Comments
IF ('A'[B] = BLANK(), 'A'[C], 'A'[D]) Cannot convert data type text to true/false
Going in circles. I need a column that does 3 evaluations on different fields and provides different results based on the different fields. Gives error cannot convert data type TEXT to TRUE/FALSE REASSIGN = IF(DetailCkReq[Batch_Str] = "REC", "RECURRING") || IF(DetailCkReq[CKREQ_ASSIGNMENT.CKREQ_NO.] = BLANK(), DetailCkReq[NAME], DetailCkReq[CKREQ_ASSIGNMENT.ASSIGNED_TO]) || IF(DetailCkReq[BATCH_ASSIGNMENT.BATCH_NAME] = BLANK(), DetailCkReq[NAME], DetailCkReq[BATCH_ASSIGNMENT.ASSIGNED_TO])Solved874Views0likes4Comments