Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |