WITH MEMBER [Measures].[Kolejnosc]
AS CASE [DIM TIME].[Month].CurrentMember
		WHEN [DIM TIME].[Month].&[January] THEN 1
		WHEN [DIM TIME].[Month].&[February] THEN 2
		WHEN [DIM TIME].[Month].&[March] THEN 3
		WHEN [DIM TIME].[Month].&[April] THEN 4
		WHEN [DIM TIME].[Month].&[May] THEN 5
		WHEN [DIM TIME].[Month].&[June] THEN 6
		WHEN [DIM TIME].[Month].&[July] THEN 7
		WHEN [DIM TIME].[Month].&[August] THEN 8
		WHEN [DIM TIME].[Month].&[September] THEN 9
		WHEN [DIM TIME].[Month].&[October] THEN 10
		WHEN [DIM TIME].[Month].&[November] THEN 11
		WHEN [DIM TIME].[Month].&[December] THEN 12
	END
MEMBER [Measures].[SredniaKroczacaBez]
AS Avg(Lastperiods([Measures].[Kolejnosc], [DIM TIME].[Month].currentmember), [Measures].[Line Total])
MEMBER [Measures].[SredniaKroczaca]
AS Round([Measures].[SredniaKroczacaBez], 2)
MEMBER [Measures].[LineTotalRounded]
AS Round([Measures].[Line Total], 2)
SELECT CROSSJOIN({
	[DIM TIME].[Year].&[2012],
	[DIM TIME].[Year].&[2013]
},{
	[Measures].[SredniaKroczaca],
	[Measures].[LineTotalRounded]
}) ON COLUMNS,
Order(
{
	[DIM TIME].[Month].Children
}, [Measures].[Kolejnosc],
	ASC
) ON ROWS
FROM [Adventure Works2014];