Forum Discussion

parry2k's avatar
parry2k
Super 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
leonardmurphy's avatar
leonardmurphy
Skilled Sharer
10 years ago

I wasn't able to recreate your original issue with the sample data given and a simple table visualization with all dates.

 

When I slice by 30/4/14, I see a Prev MTD result of 26251.

 

 

This means that, in my opinion, the behaviour you're expecting to see is the expected behaviour, and the fact you're not seeing it is a problem not related to the DAX formula.

 

I don't know what that problem is though.

 

Perhaps start from a fresh power bi file, just to see if you can recreate your own problem. If you can't, then see if you can find the difference between your original and your recreation. It could be something subtle to do with the relationships between tables, or the data itself. I'm really not sure.

 

  • parry2k's avatar
    parry2k
    Super User
    10 years ago

    if you are slicing by 30/4/2014 then current mtd will be 26251 and prev mtd (March) will be 6871 which is work fine for me as well. See case #1 in my original question.

     

    Issue is with when you slice it 31/5/2014 (case 2 in my original question)

     

    Thanks,