Continuous date from continuous number

[Anonymous]

Hello Team,

I have a table that looks like this. I have the number "11" which must be related to September 2020 and all other continuous numbers must continue the date sequence automatically. Can't come up with a variable. Please help.

[amitchandak · Accepted solution]

@Anonymous , Create a column like

format(eomonth(date(2019,10,1),[Number]), "mmmm-yyyy")

[Anonymous]

@amitchandak would never guess such a straight function. Thank you very much!