Forum Discussion

ApurvaKhatri's avatar
ApurvaKhatri
Helper III
8 years ago
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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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