blank return for a date

[sraj]

Hi Everyone,

The system is sending a default date and time (12/31/1969 6:00:00 PM) for all the open tickets, is there a way in powerbi to null the date and time it if it shows a certain date?

[smpa01 · Accepted solution]

@srajcan you please try this

calColumn= IF(DATE(YEAR('Table'[Column1]),MONTH([Column1]),DAY([Column1]))=DATEVALUE("12/31/1969"), BLANK(),[Column1])

[sraj]

This worked, thanks for your help!!

[Anonymous]

Hi @sraj 

Create a measure

IF('table'[date] = date(2021,2,1), BLANK(),'table'[date])

[sraj]

That didnt work due to this error message

IF(desk_audit'[CompletedDateTime] = date(12/31/1969), BLANK(),'desk_audit'[CompletedDateTime])

Getting this error message "To use special characters in a measure name, enclose the entire name in brackets ( [] ) and add a ] to any closing brackets in the name."