Forum Discussion

siva3012's avatar
siva3012
Helper II
9 years ago
Solved

Edit data and multiply with 1000

Hi, I have connected the data from sqlserver database to PowerBi and have uploaded the tables. I have to now change the Negative values in the Demand_Mv/Hr column into Positive by removing the Negat...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Yep, this is pretty easy to do with the Transform tab. You could also just write a line of M into the Advanced Editor.

     

    Here's a couple of screenshots. Let me know if you're not clear on any of the steps.Use "standard" operationsIf you know everything will be negative, you can simply multiply by -1000The result