Loading

WTD Calculation Not working in SSAS

Manish Sharma

9y980SQL

Hi

I am creating WTD Calculation into SSAS but it is mot working as my expectations,I want to Week to Week data from this measure for example when I select Sunday it will return 7 days data from Sunday to Saturday.

When I select Monday it will return Monday to Sunday Data.

I am Creating these WTD measures

1.Aggregate(PeriodsToDate([Time].[Time].[Week],

[Time].[Time].CurrentMember),

[Measures].[Actuals_Sales])

2.Aggregate(WTD( [Time].[Time].CurrentMember),[Measures].[Actuals_Sales])

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mukil Vendhan9y ago
kindly refer this link:http://aniruddhathengadi.blogspot.in/2011/03/how-to-calculate-ytd-qtd-mtd-and-wtd.html
0