Forum Discussion
Columns data
Why sometimes columns are perceived as a SUM and sometimes not? is that related to the data source (in this case Excel)?
Thanks!
It has to do with the data type - if the data looks like a number then PBI will assume it can be treated like a number. If you want to stop that behavior then go to the query editor and explicitly define that column as a text column.
5 Replies
It has to do with the data type - if the data looks like a number then PBI will assume it can be treated like a number. If you want to stop that behavior then go to the query editor and explicitly define that column as a text column.
Thank you! austinsense
I have the oppisit problem. Is there any way to get PBI to understand that a column (with numeric values) to be a measurement? I have tried different data types but nothing happens.
Yeah i had that same problem! I solved it by 'geting data' again, replacing the old tables with new ones and he understood the columns from new tables as a measurement.. idk why. But ofc this is not a good solution!
