I created a logic columns to get the measure of last month. No error occurs but only get the unexpected data.
Dont know why. Any advise?
Logic column: Count of Last Month=ago("TEST"."Fact Transaction"."Count" , "TEST"."Time Hierarchy"."Month" ,1)
Total->Year->Quarter->Month->Date->Hour->DateTime(key of the time dimension table)
Ticked the 'Time Hierarchy' and set the 'Chronological Key' for each level.
Have to mention that I created 2 Hierarchies for the time dimension table. The 2nd hierarchy is as below:
Seems it's caused by the 2 time-hierarchy. I built 2 time-hierarchy on one table, one has the week level the other doesn't. When I removed one, the result is correct.