Forum Discussion

louagej's avatar
louagej
Regular Visitor
9 years ago
Solved

A data refresh with Gateway Enterprise changes date from 00001-01-01 to 1899-12-30

Hi,   When my report is prepared and published, I have a colum with Estimated Date of Arrival showing me a Date. Where my date is 0001-01-01, the report shows an empty Date. This is how I al...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    louagej,

     

    As smoupre said, you could create a calculated column to work around your issue. Sample DAX.
    Column = IF(YEAR(Table2[Date])<1900,BLANK(),Table2[Date])

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

louagej,

 

As smoupre said, you could create a calculated column to work around your issue. Sample DAX.
Column = IF(YEAR(Table2[Date])<1900,BLANK(),Table2[Date])

 

Regards,

Charlie Liao

  • louagej's avatar
    louagej
    Regular Visitor
    9 years ago

    The Calculated column indeed creates a workaround.

    Thanks for the replies.