Forum Discussion
Solved
Sorting column display order
Is there any way I can get PowerQuery to recognise that these column headers are MMM-YY and sort them in a timeline fashion? I have this kind of data for 10+ years and it changes dynamically, so look...
Hi, here's the M code solution for the question. I am attaching three images. One for the source data, next for the output and last one for M code.
Table.ReorderColumns(
Source,
List.Sort(Table.ColumnNames(Source), (x) => Date.FromText(x, [Format = "MMM-yy"]))
)