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 have these problem.
Im using DIVIDE and these is the result:
First I have two values for Eslovaquia in two dates and the result is right.
But in the second, I have only one value, because in that year that country (Etiopia) didnt import so the value is 0 and even the diference was -3.909,57 the formula DIVIDE does not show the change (-100%) and so on for other countries.
How can I fix that? Make DIVIDE show the value (100% or -100%) for those countries that just have values in one date.
And I tried replacing in the formula the value BLANK() for 0 but it didnt fix the error because now it show me all the countries even those with both 0 values.
Thanks for read me!
Solved! Go to Solution.
Hi @AlejandroPCar,
Did you mean the blanks? Maybe you could try to add one more parameter to "divide".
Exportaciones Variacion % = DIVIDE ( [Diferencia]; [Exportaciones II]; 0 )
Best Regards!
Dale
Hi @AlejandroPCar,
Would you like to try this? Maybe it could work.
Exportaciones Variacion % = IF ( [Exportaciones I] = 0; IF ( [Exportaciones II] = 0; BLANK (); -1 ); IF ( [Exportaciones II] = 0; BLANK (); DIVIDE ( [Exportaciones I]; [Exportaciones II]; 0 ) - 1 ) )
Best Regards!
Dale
Hi,
Thanks for help me, but it dosent works, the result its the same I had.
Hi, I hope it can help.
Maybe I am oversimplifying, but can you just use the following, and format as a percentage in the Modeling tab?
Exportaciones Variacion % = DIVIDE ( [Diferencia]; [Exportaciones II] )
Hi @blopez11
I tried it and It works! (partially)
When the result is -100% it will be showed and it is perfect!
But, Im still having this problem:
Thanks a lot!
Hi @AlejandroPCar,
Did you mean the blanks? Maybe you could try to add one more parameter to "divide".
Exportaciones Variacion % = DIVIDE ( [Diferencia]; [Exportaciones II]; 0 )
Best Regards!
Dale
Thank you! Problem solved!
It's probably because you have blanks instead of zeros in your exportaciones columns. Try to replace blanks with zero in those columns.
Hi @Anonymous
Thanks for respond!
I dont have blanks in my exportaciones columns. Some years there are some countries and other years could be the same or others contries, but I dont have all countries all the years.
No problem.
I think you need to add some conditions to your calculations then. If exportaciones is blank, then it's dropped with 100 percent, and don't calculate if exportaciones is blank, because it will yield the result infinity.
You can try to show me your measure and how your data is stored. Then I can help you make the right measure.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |