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 q...
Need Help
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    As mentioned already my column is of date type only. Not sure if i understand your point. please suggest
    • saykasku's avatar
      saykasku
      Resolver I
      7 years ago

      U must be sure about it because no more ideas here.

       

      To test type of this column u can try to create calculated column test_column = DATEADD('DIM BillingPeriod',1,MONTH)

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Still throwing error below. Yes its date column