Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |