Forum Discussion

Power_BI_new's avatar
Power_BI_new
Frequent Visitor
3 years ago

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 ...
Need Help
tackytechtom's avatar
tackytechtom
Most Valuable Professional
3 years ago

Hi Power_BI_new ,

 

The if function works like this:

if ( Condition = TRUE, Result, AlternativeResult )

--> "if condition is true, return Resultl, else return AlternativResult"

 

In your case, I'd suggest this one here:

New =
IF ('Table'[Step] = "Ouverture", CALCULATE([T (n-1) cumul], 'repository'[category] = "1 - Net ", 'Table'[Code]= "IFRS new"),

IF ('Table'[Step] <> "", -CALCULATE([T cumul], 'repository'[category] = "2 - Total", 'Table[Code] = "new"), 

CALCULATE([T cumul], 'repository'[category] = "3 - Cash Flows", 'Table'[Code] = "IFRS new") ) ) 

 

 

Does this work?

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Power_BI_new's avatar
Power_BI_new
Frequent Visitor
3 years ago

Thanks for your answer but it doesn't work. I can't change the sign of the 3rd IF, I tried to put an ABS() but my number remains negative as if I hadn't put anything.