Date column replace to NULL or NA

Hi Anonymous ,

I can just guess what problem you might be facing. I suggest to add some error description in your questions/responses. Sample data and desired outcome clarity is expected to get the answers asap.

Below code works for me:

Replaces = IF(FORMAT(DatesReplace[Dates],"dd-mm-yyyy")="31-12-9999", "NA","GoodDates")

Output was like this:

Since we can not compare date with text, so I had to use FORMAT function. You may also need to tweak as may be needed.

Hope it helps.

Hi Anonymous ,

The NULL or NA is text type. The data is date type. If we still want to change the column type.The error "Expressions that yield variant data-type cannot be used to define calculated columns" would appear.

We can try mahenkj2 's way.

Create a measure.

mEASURE = IF(MAX('Table'[date])=DATE(9999,12,31),"NA","GOOD DATES")

Or a column.

Column = IF('Table'[date]=DATE(9999,12,31),"NA","GOOD DATES")

If I have misunderstood your meaning, please provide your pbix file without privacy inforamtion and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.