Forum Discussion
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 calcu...
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
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