PowerBI - Datetime to Date Conversion - 2024 Leap Day - Displays the Previous Day

30 Views Asked by At

I have the following date column:

enter image description here

If I apply a "Change Type" function to it to convert it from a datetime to a date:

= Table.TransformColumnTypes(#"Filtered Rows",{{"Date.Date", type date}})

The resulting date is:

enter image description here

Is that right? Is there some sort of leap second in here? Why do I see the datetime difference when I convert types?

0

There are 0 best solutions below