Need help on Nested IF condition

[Amardeep100115]

Hi 

I wish to map word "Increased By" & Decreased By" according to it's occurance in file . please help

Excel Data 

[ryan_mayu]

@Amardeep100115 

do you want to compare the diff% and previous month%diff?

if so, you can just try this

Column 2 = IF('Table'[% Diff]>='Table'[Previous Month % Diff],"Increase","Decrease")

[ryan_mayu]

@Amardeep100115 

is this what you want?

Column = 
VAR last=maxx(FILTER('Table','Table'[Index]=EARLIER('Table'[Index])-1),'Table'[% Diff])
return if(ISBLANK(last),"increased by",if(last<'Table'[% Diff],"increased by","decreased by"))

pls see the attachment below

[Amardeep100115]

Thank you for your quick response,

All down trangle should be show as "Decreased By" and up trangle should show "Increased By" 

Please help on this 
Thanks again

[ryan_mayu]

@Amardeep100115 

May I know what's wrong with the solution I provided?

[Amardeep100115]

Please have a look attached snap 

[ryan_mayu]

@Amardeep100115

pls check the attachment below

[Amardeep100115]

It seems you attached earlier file which has same result as shared snap

[ryan_mayu]

@Amardeep100115 

what's the logic for up and down triangles?