cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pap16 Frequent Visitor
Frequent Visitor

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

Untitled.png 

 

Percent.png

7 REPLIES 7
Community Support Team
Community Support Team

Re: Month over Month Percentage error

Hi Pap16,

At first, the MoM measure is in Time intelligence

143.png

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

144.png

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

145.png

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.

Highlighted
Pap16 Frequent Visitor
Frequent Visitor

Re: Month over Month Percentage error

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 Regular Visitor
Regular Visitor

Re: Month over Month Percentage error

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

Pap16 Frequent Visitor
Frequent Visitor

Re: Month over Month Percentage error

As mentioned already my column is of date type only. Not sure if i understand your point. please suggest
saykasku Regular Visitor
Regular Visitor

Re: Month over Month Percentage error

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)

Pap16 Frequent Visitor
Frequent Visitor

Re: Month over Month Percentage error

Still throwing error below. Yes its date column

error.png

Pap16 Frequent Visitor
Frequent Visitor

Re: Month over Month Percentage error

my date column has values like 2018-01-01,2018-01-13,2019-01-01,2019-01-13 etc. 

Please suggest. 

 

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,898)