Sorting Month with Power Query in 5 Minutes

In this 5 Minute Tip, Aaron walks us through a common headache for new Power Query users - the default sorting behavior for monthly data. This handy method will make your life a lot easier, and you can learn it in just a few minutes!

Want more easy tips like this? Take a look at some related playlists:

Ready to take your Power Query skills to the next level?

Check out our Excel and Power BI learning paths:

Until next time, learn on!

[wlbbviy]

What I can say for Maven Analytics is that. No one can beat them the way the team explains Thanks for the video

[marcomichelini]

Love this, and it wasn't even 5'! Only 2.5 and a great help! Looking forward to the next!

[wayneedmondson]

Awesome! That's an essential tip. Thanks for sharing. Thumbs up!

[akask]

Its done in PowerBI and not in Power Query. It does not explain how you would do it in excel power query.

[ericet]

Great video, even if I am been working with Power BI for years. Everytime I need to sort month like this my mind goes blank. I know it's easy but I always forgot how it's done. Thanks for this video.

[chriswhite]

great advice, how would you sort by month over years i.e. month 7 is July but then you get Jul-21, Jul-22, Aug-21, Aug-22 etc rather then Jul-21, Aug-21

[francoissc]

you are the best in explaining everything as simple as possible, thanks a lot for share this information!!..

[osPA]

Oh man! This is exactly what I was looking for as I am currently working on a project in where I'm attempting to measure duration. In addition to these new 5 Minute Tip videos and the resources from your courses...I think I'm in good shape! Thank you for putting this together! You guys rock!

[michelleferguson]

Do you have a video to sort date, month, and year columns in chronological order in query I can't seem to figure it out. My dates are all over the place.

[westleyempeigne]

Hey Aaron, is there a way if we need to sort the visuals based on the FY July to June?