Create a Column that numbers yearmonth periods in the Calendar

[Anonymous]

Hi Guys, How do I create a field "Period" that numbers the calendar periods so I can use it in my charts Period - 12, or -24 etc. Date Year Month Account Period Period 

[v-piga-msft]

Hi @Anonymous ,

It seems that your "Period" field like an index column. You may could create the index column in Query Editor.

If you still need help, please describe your logic of "Period" field so that we could help further on it.

Best  Regard,

Cherry

[Anonymous]

Post your sample data in table format so we can assist

[Anonymous]

O **bleep**, sorry 

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry