How to convert negative numbers into positive numbers

[pulikkan]

Hi folks,

If a column number is less tahn 0, i would like to convert to positive. Could you please let me know how can i do that. Apprciate your help on this.

Regards

Pulikkan

[v-jiascu-msft]

Hi Pulikkan,

Could you please mark the proper answer as a solution?

Best Regards,

Dale

[Greg_Deckler]

In DAX, use ABS function. Or do you want M?

[pulikkan]

M

[Greg_Deckler · Accepted solution]

Maybe something like:

new column = if [column] < 0 then [column]*-1 else [column]

Delete your old column, rename this column to your old column name.