Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
WTD Calculation Not working in SSAS
Manish Sharma
Aug 21 2017 1:17 PM
209
Reply
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])
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Query optimisation
How to Get Employees Period in Company as per Employee Joini