Forum Discussion

kincaids's avatar
kincaids
Helper II
9 years ago

default date issue

I'm having an issue with my date fields that I can't figure out.   1.  Whenever I pull in date columns, Power BI defaults them as Date/Time columns, rather than Date columns (I'm guessing this is b...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I believe that 12/30/1899 is Power BI's "default reference date". That's why he's seeing that when there are null values. I ran into this when dealing with dates before 12/30/1899 in OSU football data.

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Greg_Deckler ok that makes perfect sense, I guess I had it the wrong way around, but got pretty close :smileyhappy:

  • kincaids's avatar
    kincaids
    Helper II
    9 years ago
    So why does their have to be a value there? Why can't the date be blank like other types of cells?
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Since it seems to be a datetime datatype rather than date, try #datetime(1899, 12, 30, 0, 0, 0) rather than #date(1899, 12, 30) in your ReplaceValue step.