Forum Discussion
Solved
Display different values
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?
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
1 Reply
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