Forum Discussion
Help with average percent changes between columns
Hi! I am having trouble creating a column showing the average percent change between 5 different column values. I am new to powerBI. So I am calculating the increment increase/decrease as ([Column1]/[Column2]-1) for subsequent columns and them dividing the sum of these increments by 5, since I have 5 different values. Somehow I am getting the right results for some rows but not for others. This is really annoying.
I am currently trying this: MediaCrescimentoDerivada5Dias = divide( (divide(vwPrevisaoParametros[DerivadaC+1];vwPrevisaoParametros[DerivadaC])-1) + (divide(vwPrevisaoParametros[DerivadaC+2];vwPrevisaoParametros[DerivadaC+1])-1) + (divide(vwPrevisaoParametros[DerivadaC+3];vwPrevisaoParametros[DerivadaC+2])-1) + (divide(vwPrevisaoParametros[DerivadaC+4];vwPrevisaoParametros[DerivadaC+3])-1) + (divide(vwPrevisaoParametros[DerivadaC+5];vwPrevisaoParametros[DerivadaC+4])-1);5)
Thanks for the help!
Anonymous , I am assuming you have done it for all the formula, try this also for all formula's
divide([Column1] -[Column2],[Column2],0)
If it does not work. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
3 Replies
Anonymous , use this
divide([Column1] -[Column2],[Column2])
Hi amitchandak thanks for your answer! Unfortunately it did not solve the problem. Still showing correct results for some rows but incorrect ones for others.
Anonymous , I am assuming you have done it for all the formula, try this also for all formula's
divide([Column1] -[Column2],[Column2],0)
If it does not work. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.