power query dates are 12/30/1899 after pivoted column

[RattlingCarp3048]

i am new-ish to using power queries and am trying to transform a large data set. i have a column with different departments but the values are date/times and are formatted as "mm/dd/yyyy hh:mm:ss am/pm" in the original data set. when i add the original data to a power query the dates are still formatted correctly and reflect the correct format as the data type. However, when i pivot the department column and select the date/time column as my values, the dates are completely reformatted to a decimal number and reflect 0 and 1. when i change the data type back to date/time it shows 12/30/1899. how do i get it back to the original date/time??

 

[alansidman]

Click on Advanced Options and select "Don't Aggregate"

 

[RattlingCarp3048]

Thank you!! Worked like a charm.