Forum Discussion

Anonymous's avatar
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...
Need Help
  • djurecic's avatar
    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?

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution 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's avatar
    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