Forum Discussion
Data Scale
Maybe the easiest solution at this point is just to multiple my measures by 1000.
The Auto function doesn't account for my data being in thousands already. While a calculated column would fix the issue I have around 100 Columns per table and about 5 tables so far. I feel that would potentially lead to errors and a lot of ram being used.
There is a function(Standard) at the top of query editor under the transform tab that will allow you to multiply columns, but it will not let me do multiple columns at a time and I don't want to manually adjust 500+ columns of data.
We need a setting in the query editor that will allow us to specify whether our data is in real numbers, thousands, or millions etc.
Maybe the easiest solution at this point is just to multiple my measures by 1000.