Wrong growth rate

Question

I'm currently working on calculating the growth rate in Power BI using DAX programming, but I've hit a snag. Unfortunately, I'm having trouble with -1 divided by zero and it's giving me an incorrect calculation. I was wondering if anyone could lend a hand and help me fix this error. Thanks in advance!

Code: Sales growth = CALCULATE([2024]-[2023])/[2023]

Answer 1

Try using divide function instead:

Sales growth = ROUND([2024]-[2023],0)/ROUND([2023],0)