Forum Discussion

sdiniz's avatar
sdiniz
New Member
4 years ago
Solved

Percentil error - Expressions that yield variant data-type cannot be used to define calculated colum

Hi, I'm having problems with the Percentile calculation, it used to work normally, but I think that after updating, something starts to go wrong. Below link to the PBI: https://1drv.ms/u/s!Ap...
Need Help
  • sdiniz73's avatar
    sdiniz73
    4 years ago

    Thanks. I had already tried that too, but in my case it didn't work. As I had other problems on the computer, I decided to perform the formatting and now it is working.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, sdiniz 

I opened your attachment and got the same error message as you did.
As the error message suggests, the problem occurs with the data type.
In your attachment, the data type of the [Valor] column was whole number, so I changed the data type to decimal number and the error disappeared.

 

 

Best Regards,
Community Support Team _ Zeon Zheng


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

sdiniz73's avatar
sdiniz73
Regular Visitor
4 years ago

Thanks. I had already tried that too, but in my case it didn't work. As I had other problems on the computer, I decided to perform the formatting and now it is working.