Forum Discussion
Months in the wrong order
Try this in the Query Editor:
Table.AddColumn(<YOURLASTSTEP>, "YYYYMM", each "2017."&Number.ToText([Mes]))
I do not master this system. Please if you can pass me by what exactly I should write! Based on the name of my table, in the name of my date column, because I am not able to apply the formula.
THIS APPEAR: https://drive.google.com/file/d/0B1b9zTy_CQcRYkdXV29heUhRakU/view?usp=sharing
I did a spreadsheet with some tables. One of them relates month, result and goal. I have ordered the months in abbreviated form (JAN, FEB, etc.). But the panels do not accept the fixed order of the annual calendar. What appears is: February, January, April, August ... Can anyone help me? I'll attach the panel image and the data source worksheet. My idiom on the spreadsheet is portuguese.
Dashboard= https://drive.google.com/drive/folders/0B1b9zTy_CQcRVmNjWjh0bURidlE
WorkSheet: https://drive.google.com/drive/folders/0B1b9zTy_CQcRVmNjWjh0bURidlE
I would suggest you to create the column in "GetData" aka PowerQuery and not in the DAX formula Bar.
My formula won't work in DAX as it is a Power Query formula.
If you have problems, I can create a gif for you.