Comparing Bewteen lastmonth and lastyear same month data

[SureshPantra]

Hi,

Am trying to create a column for the data which is shown below,

Column1	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May
A		25	25	25	25	25	25	25	25	25	25	25
B	23	23	23	23	23	23	23	23	23	23	23	23
C	22	22	22	22	22	22	22	22	22	22	22	24
D		23								23	23	23
E	23	23	23	23	23	23	23	23	23	23	23
F		25		25	25	25	25	25	25	25	25	25
G	23	23	23	23	23	23	23	23	23	23	23	23
H	69	69	69	69	69	69	69	69	69	69	69	34
j		11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5

Need to compare and create a column, if jun or may we dont have data it has to show "N/A" and if data is there it has to comapre and return increase or decrease.

Expecting output as below.

Column1	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Status
A		25	25	25	25	25	25	25	25	25	25	25	N/A
B	23	23	23	23	23	23	23	23	23	23	23	23	No Change
C	22	22	22	22	22	22	22	22	22	22	22	24	Increase
D		23								23	23	23	N/A
E	23	23	23	23	23	23	23	23	23	23	23		N/A
F		25		25	25	25	25	25	25	25	25	25	N/A
G	23	23	23	23	23	23	23	23	23	23	23	23	No Change
H	69	69	69	69	69	69	69	69	69	69	69	34	Decrease
j		11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	11.5	N/A

Thanks in Advance.

Regards,

Suresh.

[TeigeGao · Accepted solution]

Hi @SureshPantra ,

Status =
IF (
    Table1[Jun] = BLANK ()
        || Table1[May] = BLANK (),
    "N/A",
    IF (
        Table1[Jun] = Table1[May],
        "No Change",
        IF (
            Table1[Jun] < Table1[May],
            "Increase",
            IF ( Table1[Jun] > Table1[May], "Decrease" )
        )
    )
)

The result will like below: 

Best Regards,

Teige