Forum Discussion
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!ApEH6XDhi5ERiIl5S4hWSjRbNEy32A?e=PAl8xp
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.
3 Replies
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.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.
I did a test on a virtual machine with windows 10 and look at the result;
Virtual Machine (Windows 10): Local Machine (Windows11)
