Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

blank return for a date

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?   ...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago

    srajcan you please try this

    calColumn= IF(DATE(YEAR('Table'[Column1]),MONTH([Column1]),DAY([Column1]))=DATEVALUE("12/31/1969"), BLANK(),[Column1])
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sraj 

Create a measure

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

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
5 years ago

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."