Forum Discussion
parry2k
Super User
Super UserMTD questions
Hello all, I have interesting question on MTD functionality and here is the question: I have a date dimension as we know as best practice we should have date dimension and I do have one. I ha...
parry2kSuper User
Super UserHere is once again:
If I'm slicing the data on April 30th, 2014, works great, results below.
Curr MTD is 26251 (includes April 01st to April 30th)
Prev MTD is 6871 (includes Mar 01st to Mar 31st)
If I'm slicing the data on May 31st, 2014, results are wrong and this is what I'm getting
Curr MTD is 24865(should includes May 01st - May 31st but we have data until May 27th) -> result is correct
Prev MTD is 22260 (it is only including data from April 01st - April 27th) -> result is wrong
I expect following reuslt in this case
Prev MTD is 26251 (April 01st - April 30th)
Hope it is clear.
parry2kSuper User
Super UserAny other help/solution? I'm kind of stuck here not to move further my development until it is resolved.
Thanks!
P