cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Evuleocha1974
New Member

Power BI

Hello Team,

Please can someone direct me on how to convert negative values to positive ones in the power query?

It seems easy but I am stuck with it.

 

Thank you.

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@Evuleocha1974 Number.Abs Number.Abs - PowerQuery M | Microsoft Learn


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

mussaenda
Super User
Super User

Hi @Evuleocha1974,

 

You can simply select the absolute value

Power Query > Transform > Standard > Absolute Value

mussaenda_0-1675053708270.png

 

View solution in original post

2 REPLIES 2
mussaenda
Super User
Super User

Hi @Evuleocha1974,

 

You can simply select the absolute value

Power Query > Transform > Standard > Absolute Value

mussaenda_0-1675053708270.png

 

Greg_Deckler
Super User
Super User

@Evuleocha1974 Number.Abs Number.Abs - PowerQuery M | Microsoft Learn


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors