Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |