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 Negative sign before it and multiply the data with 1000. Has anyone have edited/Changed the data  for their needs ? Can anyone provide a solution to this ?   

Need Help
  • 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

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

     

    • siva3012's avatar
      siva3012
      Helper II
      9 years ago

      Anonymous: Thanks for the screenshot and the code in Advanced editor. It was easy for me to undesrstand as i am new to the PowerBI. 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    siva3012

     

    Hi, You can do all this in Query Editor.

     

    With Transformation Actions.

     

    Victor

    Lima Peru