Create a new column where only one value is filtered from another column

[Anonymous]

Hi there,

I am trying to create a new column in DAX which looks exactly the same as an existing column but has a certain date value removed. I want the date "12/31/2154 12:00:00 AM" removed in the new column. Anyone know what kind of DAX expression I need to fill in to make this happen?

Thanks!

[amitchandak · Accepted solution]

@Anonymous ,

if([Date]<> date(2154,12,31) , [Date], blank())

[Anonymous]

This did the trick! Thanks!