•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to stop Data Model from converting Date-only to Date-time when loading from Power Query? How to stop it from altering month sort order?
A data column containing the date as 01-Jan-16 (for example) inside Power Query becomes 01-Jan-16 12:00:00 AM when the table is loaded into the Excel data model.
Additionally, inside the PQ, months are sorted from Jan to Dec, but when imported they start in July instead.
How can I stop Data Model from changing up my data?
[link] [comments]
Want to read more?
Check out the full article on the original site