Forum Discussion
Sign dependency between IF Dax
Hello, I created this calculated column. I have a problem because the sign of the second IF impacts the sign of the 3rd IF. I tried to work around by storing the second IF in a variable but nothing ...
Can you share a screenshot and describe the business logic? I think I have not yet understood what you would like to achieve 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
When I add the - in front of the 2nd IF, it shows me the correct results in my table, but it affects the sign of my 3rd IF. This turns my result into a negative for me, when I want it to be positive.
Between the 2- and the 3-, some lines share common accounts, I don't know if this can be the cause
