Creating a list with cicle and years

[CSpina]

Hi, people!

I need to create a list with cicle and year.

1-2010
2-2015
3-2020

I am using

let
ano05 = 2010,
AnoAtual = 2021,
troca04_ciclo = 60,
Fonte = List.Generate(()=>ano05, each _ <= AnoAtual, each _ + Number.RoundUp(troca04_ciclo/12))
in
Fonte

But I don´t know how to do it.

Any ideias?

[AlexisOlson · Accepted solution]

If you want a list {"1-2010", "2-2015", "3-2020"}, then you could try this:

let
    ano05 = 2010,
    AnoAtual = 2021,
    troca04_ciclo = 60,
    step = Number.RoundUp(troca04_ciclo / 12),
    N = Number.RoundUp((AnoAtual - ano05) / step),
    Fonte = List.Transform({1..N}, each {_, ano05 + step * (_ - 1)}),
    ToText = List.Transform(Fonte, each Number.ToText(_{0}) & "-" & Number.ToText(_{1}))
in
    ToText