Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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?
In direct query u can convert colmn to data type and use it like above.
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)
Still throwing error below. Yes its date column
my date column has values like 2018-01-01,2018-01-13,2019-01-01,2019-01-13 etc.
Please suggest.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |