Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Colin
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
kcantor
Community Champion
Community Champion

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
Colin
Frequent Visitor

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

 

 

Beckham
Advocate II
Advocate II

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

Sean
Community Champion
Community Champion

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!

Colin
Frequent Visitor

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

kcantor
Community Champion
Community Champion

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!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.