Display different values

[ApurvaKhatri]

Hello,

I have a column 

Month

Jan

Feb

March

April

...

Dec

I need to display as

Month   Next Month

Jan         Feb

Feb       March

March  April

......

Like if the Month is Jan, Next Month should display Feb

How do I acheive this?

[Anonymous · Accepted solution]

@ApurvaKhatri,

You can create the following calculated columns in your table.

NextMonth Number = SWITCH(Table[Month],"Jan",1, "Feb",2,"March",3,"April", 4,"May",5,"June",6,"July",7,"August",8,"September",9,"October",10,"November",11,"December",12)+1

NextMonth = If (Table[NextMonth Number]=13, "Jan", SWITCH(Table[NextMonth Number], 2,"Feb",3,"March",4,"April", 5,"May",6,"Jun",7,"Jul",8,"August",9,"September",10,"October",11,"November",12,"December"))

Regards,
Lydia