Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 years ago

MTD 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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

 

 

OK, but then I am confused by this statement from the original post:

 

 

"this is the total of April until last transaction date of May 27th whereas for April I expect the total until April 30th..."

 

PARALLELPERIOD will give you what is stated originally. Given DATESMTD of May 1st - May 27th, PARALLELPERIOD should return April 1st - April 30th.

 

Your DATEADD fucntion from the original post is returning April 1st - April 27th.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 years ago

Here 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.

 

 

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    10 years ago

    Any other help/solution? I'm kind of stuck here not to move further my development until it is resolved.

     

    Thanks!

    P