Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm having trouble with a formula. I'm trying to show all growth rates year by year, without one year.
Measure green bar is
(Sum({<Ano>}[Volume_projetado])/above(Sum({<Ano>}[Volume_projetado]-1))-1)
That plot all years 2016 to 2022.
Im trying 2016 to 2021 (without 2022)
That was all my attempts, and i failed:
What I supose to do?
Tks
Like this perhaps
(Sum({<Ano={'*'}-{2022}>}[Volume_consolidado])/above(Sum({<Ano={'*'}-{2022}>}[Volume_consolidado]-1))-1)