This content has been marked as final. Show 7 replies
When the time dimension's chronological key is incorrect, there would generally be issues during time series functions usage. So, just check your chronological key for the lowest level in your period hierarchy if was set properly or not.
Hope this helps. If you are still unable to get it, please post more details of your hierarchy design, the period dimension sample data.
Can palce your ago function expression?
Ago(<<Measure>>, <<Level>>, <<Number of Periods>>)
Ago("Sales"."Base Measures"."Dollars" , "Sales"."Time MonthDim"."Quarter" , 1)
For more refer,