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])
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!!