Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Month over Month Percentage error

Hi,

 

I am getting below error when trying to do month over month percentage calculation. First of all I dont see Month over Month option under Quick Measure using June 2019 version.I have direct query model. Billing period is date column. & i have a percentage column. Any way to achieve this? Thanks

 

 

Need Help

7 Replies

  • dax's avatar
    dax
    Community Support
    7 years ago

    Hi Pap16,

    At first, the MoM measure is in Time intelligence

    In addition, you use a field which not  a date type will cause this error

    You could try to change data type to date like below, which will work well

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am using Direct Query model as mentioned before. So i dont see an option for Time intelligence. Is there any other way to do this?

      • saykasku's avatar
        saykasku
        Resolver I
        7 years ago

        In direct query u can convert colmn to data type and use it like above.