Forum Discussion
rbowen
Helper III
Helper IIIFlip Number To Negative Based On A Different Column
Howdy All - I'd like to create a calculated column that flips a number to it's negative value based on a second column's designation of debit or credit. The table below is the one I'm trying to...
There is the ABS function in dax: https://learn.microsoft.com/en-us/dax/abs-function-dax
but, you can always just use -1 * [amount], or even -[amount]
vicky_
Super User
Super UserThere is the ABS function in dax: https://learn.microsoft.com/en-us/dax/abs-function-dax
but, you can always just use -1 * [amount], or even -[amount]
rbowenThank you Vicky, that worked.