Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Unit Conversion

My data is in kilowatts, but I would like to show that table in Megawatts.  1 kilowatt = .001 megawatt.  How can I do this without creating a new data column, can I just do some sort of measure calculation?  I am new to Power BI, if you could not tell.

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

You could create a new measure to do this. It would look roughly something like the following, but you'd have to put in the correct table and column names.

 

Megawatts = SUM( <your_table>[Kilowatts] ) * 0.001

View solution in original post

1 REPLY 1
d_gosbell
Super User
Super User

You could create a new measure to do this. It would look roughly something like the following, but you'd have to put in the correct table and column names.

 

Megawatts = SUM( <your_table>[Kilowatts] ) * 0.001

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.