Forum Discussion
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...
So why does their have to be a value there? Why can't the date be blank like other types of cells?
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.