•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#real-time collaboration
#Data Model
#Date-only
#Date-time
#Power Query