I used the following to show YTD sales (it works fine)
I also created the following to get YTD for previous years (Quaters, months)
FY-1 Sales: ([Measures].[FY YTD Sales],
These work fine also however I am concerened that I need to keep explaining that since the current quarter is not complete the number is lower for this year than last year.
Is there a better way to do this that would only include previos years data up to this "day of year"
Another choice may be not to include incomplete periods. While not as desireable as the first mehtod, is there a way to do this?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?