Forum Discussion

Jolyon's avatar
Jolyon
Icon for Helper III rankHelper III
9 years ago

how to sort Date (MonthYear column)?

Hello, need urgent help of yours:   I have a column Date (e.g. 01.01.2016), then I added columns Month and Year and concatenated them to get the column MonthYear(e.g. January2016):     No...
Need Help
theov's avatar
theov
Icon for Advocate III rankAdvocate III
4 years ago

You can make a calculated column and magnify year's importance by multiply to 100 and add month and sort your column by new column. I'd rather put year month 🙂 Here is a comprehensive video about calendar in power BI also :

https://www.youtube.com/watch?v=Oq5WOmo94_Q