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?

djurecic's avatar
djurecic
Icon for Super User rankSuper 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?