Forum Discussion
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"
but I get this error "Expressions that yield variant data-type cannot be used to define calculated columns"
Hi Anonymous
You may try
Status = IF ( 'Fact-Tasks'[Closed] = BLANK (), "Pending", 'Fact-Tasks'[Closed] & "" ) )
2 Replies
- tamerj1
Community Champion
Hi Anonymous
You may try
Status = IF ( 'Fact-Tasks'[Closed] = BLANK (), "Pending", 'Fact-Tasks'[Closed] & "" ) )