2023-06-07

Convert Negative to Positive Based on Another Column in Power Query

I have some data that is negative and I need to convert it to a positive but it has to be based on another column.

So this is what I have:

each if ([Column1]< 0 and [Column2] = "X") then [Column1] *-1 else [Column1] *1) 

But I can't get it to work. Column1 is the values and Column 2 is the one with the text.

Any ideas? Thanks



No comments:

Post a Comment