Forum Discussion
Solved
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. ...
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.
Beckham
Advocate II
Advocate IIYou could do this equation: if [column] <0 then [column]*-1 else [column]