Forum Discussion

sraj's avatar
sraj
Responsive 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])

4 Replies

  • smpa01's avatar
    smpa01
    Community Champion
    5 years ago

    srajcan you please try this

    calColumn= IF(DATE(YEAR('Table'[Column1]),MONTH([Column1]),DAY([Column1]))=DATEVALUE("12/31/1969"), BLANK(),[Column1])
    • sraj's avatar
      sraj
      Responsive Resident
      5 years ago

      This worked, thanks for your help!!

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