How to order month on a table?

[Anonymous]

Hi guys,

I'm trying to model my month table so it will appear in my table correctly, but it's doing alphabetically.

Can anyone give a hand? I wanna order by year and month.

P.S. I did the sort by column and gave a numeric column as reference, but it's not the correct order

thanks!

[Phil_Seamark]

Hi @Anonymous

You need to use the "Sort by column" feature to force the sort order of your months to be based on a numeric column.

[Anonymous]

Hi, Phil.

I did that, but it is giving me that result you see on the image. Only the year 2010 (October - December) is right, all the others are in the wrong order.

[Phil_Seamark]

Hi @Anonymous

Does the column you are sorting by contain both the year and month as part of it?  eg,

YYYYMM

or 

201001

201002

201003

etc

You can generate this using the format command, eg, = FORMAT([date col],"YYYYMM")

[Anonymous]

Hi Phil

so I created the new YM column, but when I click on my Month name column and sort by YM, it gives me this error: There can't be more than one value in YM column for the same value in Month Name.

Any ideia why?

[ricardocamargos]

Hi @Anonymous,

Can u create a new column (month order column) like (if January = 1, February = 2... and do so..) ?

After that try to sort by this new column.

I hope it helps you.

[Anonymous]

Hi @ricardocamargos, I did that before didn't work tough

But thanks.

[Ashish_Mathur · Accepted solution]

Hi,

I just removed the Acidentes column and added it back.  It worked fine.

[Anonymous]

Thank you @Ashish_Mathur.  It worked. Happy to learn this trick.

[Phil_Seamark]

Probably because there is some weird overlap?

Any chance you can send a cut down version of your PBIX File?  maybe make a copy, delete any non-essential tables and send it through so we can take a look

[Anonymous]

Sure, here it is https://drive.google.com/file/d/0B0Q4COA8ZnwpMDFzWWh0aTdsTlU/view?usp=sharing