Forum Discussion
Power Query: Always getting DataFormat.Error We couldn't convert to Number
Sure. First here is the pivot options box.
When I click on OK, I get the following:
We are taking average of the values. But since it has "true" value it cannot take the average.
You can take min or max.
Please let me know if this didn't work.I'm afraid I don't follow. There is no Boolean (TRUE/FALSE) column, and if something is being converted into Boolean, then something else is going wrong earlier on. The "value column", which the aggregation function ought to be applied to is a column of (decimal) numbers. So it certainly should be able to take the average.
On a related point, if I understand your comment correctly, you are saying that I cannot average a Boolean column to find the proportion of true values? Or, more precisely, Booleans are not cast to numbers [true = 1; false = 0] when applying numerical operations, unless one explicitly changes the type?