Forum Discussion
Colin
10 years agoFrequent 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. ...
- 10 years ago
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.
Sean
Community Champion
10 years agoCan you post a picture so we see where this is happening?
EDIT: I should have read the Title :smileylol: in the Query Editor - nevermind :smileylol:
So that link should help!
Colin
10 years agoFrequent Visitor
Thanks for the reply Sean. The link kcantor sent did the trick.