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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

That seems like a bug. That date is the base date in Power BI. You should be able to fix it in Power BI (work-a-round) by creating a calculated column in either M or DAX.