Manish Sharma

Manish Sharma

  • NA
  • 34
  • 10k

WTD Calculation Not working in SSAS

Aug 21 2017 1:17 PM
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])
 

Answers (1)