Sorting Months in PowerPivot

[ImadDabbura]

Hey guys,

I have sales for 3 products over time which means i have 3 same months for different categories.
Product A Jan
Product B Jan
Product C Jan

How can i sort months in powerpivot other than YearMonth because it doesnot work?


Thanks

 

[scottsen]

The "Jan" is in your sales table, or do you have a separate Calendar table? What do you want the output to actually look like? Why does YearMonth "not work" ?

 

[ImadDabbura]

The "Jan" is in your sales table, or do you have a separate Calendar table? What do you want the output to actually look like? Why does YearMonth "not work" ?

I have column for dates and i used FORMAT formulas to add Month,Day, and Year columns in PowerPivot.
When presenting the data via PowerView, the Months are shown in alphabetic order. I tried the monthyear trick but its giving me error message that cant be sorted because there is more than one data for each month per year which make sense.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Year[/TD]
[TD]Month
[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]2005
[/TD]
[TD]June[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]2005[/TD]
[TD]June[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]2005[/TD]
[TD]June[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]2006[/TD]
[TD]July[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]2006[/TD]
[TD]July[/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD]2006[/TD]
[TD]July[/TD]
[/TR]
</tbody>[/TABLE]

 

[scottsen]

You need a column of "month numbers" (june=6, etc) then you can sort your current Month column by the new MonthNum column.

 

[Kazlik]

If you make a new column of "month numbers" (june=6, etc) as Scott noted and then make a new column with =CONCATENATE([Year],[month numbers]) you can then use the Sort Column By on the Home tab where you sort the Month column which has June, July in it.