Edit data and multiply with 1000

[siva3012]

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 ?   

[Anonymous · Accepted solution]

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]

@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]

@siva3012

Hi, You can do all this in Query Editor.

With Transformation Actions.

Victor

Lima Peru