Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to calculate Growth percentages and did not succeed. Could somebody help me?
For example in the following table:
How to calculate the growth from units 2020/Units 2019 for example. In percentage.
Thanks,
Vera
HI @verafa
Try like below
([units 2020] - [Units 2019]) / [Units 2019]
Thanks, it gaves me the clue! (Sum({<Year={2020}>}[Sales Units])-Sum({<Year={2019}>}[Sales Units]))/Sum({<Year={2019}>}[Sales Units])
HI @verafa
Try like below
([units 2020] - [Units 2019]) / [Units 2019]
Thanks, it gaves me the clue! (Sum({<Year={2020}>}[Sales Units])-Sum({<Year={2019}>}[Sales Units]))/Sum({<Year={2019}>}[Sales Units])