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.
Not sure why this is returning such a strange result:
Expenses YOY % = IF([Expenses Prior Year]=0,BLANK(),DIVIDE([Expenses]-[Expenses Prior Year],[Expenses Prior Year]))
The curent year expenses in this category are $20,655.12. The prior year's expenses in this category were zero. I am trying to get the percentage increase in expenses.
The result I get is 394965993271454000%.
Thanks.
Solved! Go to Solution.
Found the problem. The measure [Expenses Prior Year] actually came to 0.000000000005230, which is a different problem.
Looks like my measure to calculate the percentage increase was working exactly the way intended.
Sorry for the confusion!
Found the problem. The measure [Expenses Prior Year] actually came to 0.000000000005230, which is a different problem.
Looks like my measure to calculate the percentage increase was working exactly the way intended.
Sorry for the confusion!
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |