Forum Discussion
Helper IISort months previous year against current year
hi munchkin666
For your case, you could use sort by column in power bi to get it.
https://radacad.com/sort-by-column-in-power-bi
Then just create a order column as this:
Order = MONTH([Date])*10000+YEAR([Date])Then selected YearMonth column, click ->sort by columns->Order
and here is sample pbix file, please try it.
Regards,
Lin
Helper IIUnfortunatley it didnt work. Do you have any other ideas? I would apprecaite any help. I only want to put the columns in a different order
Jan 2019 Jan2020 Feb2019 Feb2020 etc
Community Supporthi munchkin666
For your case, you could use sort by column in power bi to get it.
https://radacad.com/sort-by-column-in-power-bi
Then just create a order column as this:
Order = MONTH([Date])*10000+YEAR([Date])Then selected YearMonth column, click ->sort by columns->Order
and here is sample pbix file, please try it.
Regards,
Lin