Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Wrong result of Convert String to Int

Hi, I have table Units with column UnitId1 which contain numbers in format string, I created calculated column UnitId with function

UnitId = CONVERT(Units[UnitId1], INTEGER)

but it return 1 for all rows. See picture. What is wrong?

Thank you for help

djurecic
3 years ago
Hi Anonymous ,

Hi PetrK,
Is it possible that the matrix is showing a count of UnitID or other aggregation of the column? What does data view show?

3 Replies

mangaus1111
Solution Sage
3 years ago
Hi Anonymous ,
why don´t you change the data type in power query? It is much easier in my opinion.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  3 years ago
  Data source is Direct Query, so it is not possible to use Power Query. I have found cause. In visual table column UnitId was set on "Count". After change to "Don't summarize" it is OK
djurecic
Super User
3 years ago
Hi Anonymous ,

Hi PetrK,
Is it possible that the matrix is showing a count of UnitID or other aggregation of the column? What does data view show?

Related content