Forum Discussion

phillgrey's avatar
phillgrey
New Member
4 years ago
Solved

couldn't load the data for this visual error , caculation error in measure

Can anyone help, I keep getting the following error when trying to create a column with line series model. I have create two calculations using a SUM, converted the data type to an INT in SQL and also to a whole number in BI, still wont work. Any ideas? Thanks
  • phillgrey 

    You can try using the "VALUE() function" in the column, but you should certainly be able to change it within power query

2 Replies

  • RayWu's avatar
    RayWu
    Icon for Memorable Member rankMemorable Member

    phillgrey 

    You can try using the "VALUE() function" in the column, but you should certainly be able to change it within power query

    • phillgrey's avatar
      phillgrey
      New Member

      Thanks, Im trying to do it SQL side to help with performance but the power query work . Cheers!