Thank you! Both approaches are pretty similar. Parsing turns text into a date, while changing the type makes sure Power Query treats the data as a date, which only works if the data is already in a date-friendly format. A slight difference in error handling.
Thanks! Btw, if you'll deal with a large data set, there is another approach you may like too: ruclips.net/video/iMeuit1IiE4/видео.html It'll work a bit faster because it avoids the double transposition.
Great I loved it, especially the Parse Date. I've never seen it before. I usually just change the Data Type.
Thank you! Both approaches are pretty similar. Parsing turns text into a date, while changing the type makes sure Power Query treats the data as a date, which only works if the data is already in a date-friendly format. A slight difference in error handling.
@@howtolearnexcel Aha, thank you for explaining the difference. Appreciate your response. 🤝
Super ❤👍
Thanks! Btw, if you'll deal with a large data set, there is another approach you may like too:
ruclips.net/video/iMeuit1IiE4/видео.html
It'll work a bit faster because it avoids the double transposition.
An alternative approach is covered here (by @basensei8699 ):
ruclips.net/video/iMeuit1IiE4/видео.html
Thanks , if you can provide the data spreadsheet it will be easy to practice. … anyway.
Sorry, here it is:
docs.google.com/spreadsheets/d/11WpVGlYJLuJAgreN16MvwCoTTGPeKZp-/edit?usp=drivesdk&ouid=108776671615330203341&rtpof=true&sd=true