Handle negative number to show the performance correctly

[KH_Mike]

Hi All,

I have a set of financial data which contain negative number. I make to measure to sum the "This Year Result" and "Last Year Result". Right now, I would like to create new measure "My IDeas" to show the performance accordingly. However, some negative number make me confuse and not sure how to write the DAX. Any people have experience to handle this situation?

LYR	TMR	Change	Change %	My Ideas
-100	-80	20	-20%	Improve
-100	-120	-20	20%	Not Improve
-100	90	190	-190%	Improve
100	-90	-190	-190%	Not Improve
100	120	20	20%	Improve
120	100	-20	-17%	Not Improve

[Greg_Deckler]

@KH_Mike Maybe:

My Ideas =
  SWITCH(TRUE(),
    [Change]>0,"Improve",
    [Change]<0,"Not Improve",
    "Unchanged"
  )

[KH_Mike]

Hi @Greg_Deckler ,

Thank you. If I want to include one more criteria (e.g.: Change More / Less than 10%) how to amend the DAX? Because for the first row or recrod, if I just calculate the change in %, then it will become negative change. In reality, that is really a improvement. Thank you.

[Greg_Deckler]

@KH_Mike When checking the % use ABS for absolute value? Or when caculating the change use ABS for LYR like:

[Change] / ABS([LYR]) 

Probably ought to do that anyway.

[KH_Mike]

Hi @Greg_Deckler ,

Seems the logic should be use the absolute value for % and positive change then "Improve". If negative change then "Not Improve". Thank you.