Forum Discussion

LFM's avatar
LFM
Icon for Helper III rankHelper III
2 years ago
Solved

Abs function in power query

Hello. I want to add a new column with the absolute value of a anothe column in Power query. I tried the formula as shown under, but it doesnt seem to work like in dax measures. I want a column with the absolute value of the column expoure. What function can I use to calculate this?

1 Reply

  • m_dekorte's avatar
    m_dekorte
    Icon for Resident Rockstar rankResident Rockstar

    Hi LFM,

     

    Use this:

    Number.Abs([Exposure])