cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Absolute Value Query Editor

Hi everyone,

 

I'm trying to add a custom column in the data view that calculates the absolute value of another column in the data. PowerBi is telling me that it doesn't recognize the expression. 

 

 

My expression is written as follows:

 

=ABS([Balance])

 

I'm not sure what to try next. My internet research told me to write the syntax as I have above. Any guidance would be greatly appreciated. 

 

Best,

 

Colin

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: Absolute Value Query Editor

If you are going column to column I would suggest using the query editor. Here is a link with the expression you  need:

https://msdn.microsoft.com/en-us/library/mt253322.aspx?f=255&MSPPError=-2147217396

 Perhaps the DAX requires it to be in a measure instead of a column. Not sure, haven't used it myself.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Highlighted
Super User I
Super User I

Re: Absolute Value Query Editor

If you are going column to column I would suggest using the query editor. Here is a link with the expression you  need:

https://msdn.microsoft.com/en-us/library/mt253322.aspx?f=255&MSPPError=-2147217396

 Perhaps the DAX requires it to be in a measure instead of a column. Not sure, haven't used it myself.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Community Champion
Community Champion

Re: Absolute Value Query Editor

Can you post a picture so we see where this is happening?

 

EDIT: I should have read the Title Smiley LOL in the Query Editor - nevermind Smiley LOL

 

So that link should help!

Highlighted
Helper II
Helper II

Re: Absolute Value Query Editor

You could do this equation: if [column] <0 then [column]*-1 else [column]

Highlighted
Frequent Visitor

Re: Absolute Value Query Editor

All set. Thank you so much! That link will prove really helpful. 

 

 

Highlighted
Frequent Visitor

Re: Absolute Value Query Editor

Thanks for the reply Sean. The link kcantor sent did the trick.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors