Forum Discussion

LizHackett's avatar
LizHackett
Regular Visitor
9 years ago
Solved

Calculate temperature celsius from fahrenheit

Hi all,   I'm new to DAX, and struggling to figure this measure.   We have a column of fahrenheit temperature and want to add an extra column with the corresponding Celsius, help!  
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi there you can create a new column with the following below.

     

    Celcius = ('Tablename'[Fahrenhiet]-32) * 0.5556

     

  • KarlinOz's avatar
    KarlinOz
    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

     

  • Interkoubess's avatar
    Interkoubess
    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

In case you need to go the other way from fahrenheit to celsius here is the formula I used:

Temp (°F) = ([Temp (°C)] * 1.8) +32