Forum Discussion
Calculate temperature celsius from fahrenheit
- 9 years ago
Hi there you can create a new column with the following below.
Celcius = ('Tablename'[Fahrenhiet]-32) * 0.5556 - 9 years ago
Hi LizHackett,
I think you would add a new calculated column rather than a measure with the formula to convert; something like:
Name_for_your_DegC_column = DIVIDE((Name_of_your_table[Name_of_your_column_with_DegF_values]-32)*5,9)
HTH,
Karl - 9 years ago
Hi LizHackett,
Either in Power Query you create a costum column with this formula as follow where my column with farhenheit data is named Fahren : ([Fahren]-32)*5/9
Or in the Power Bi desktop, you create a column with the same formula ([Fahren]-32)*5/9
Thx,
Ninter
Hi LizHackett,
Either in Power Query you create a costum column with this formula as follow where my column with farhenheit data is named Fahren : ([Fahren]-32)*5/9
Or in the Power Bi desktop, you create a column with the same formula ([Fahren]-32)*5/9
Thx,
Ninter