In a Pivot Table, I have a list of annual results in a column.
I need to measure the annual change percentage, E.I. =(C8-C7)/C7.
The column C header is: Annual Result.
Can anybody help me with the way to calculate this?
Could you post a chunk of example data, and possibly your desired outcome?
Thank you Thomas.
I managed to solve the problem.
All the best
Hi, I have similar problem.
I tried different conditional sums using CALCULATE and SUM functions, but the result somehow it did not work out as expected, because I could not divide e.g. 7th row by 8th row.
Is it possible that you help me with your solution?
Engage and empower students with Power BI!
Continue your learning in our online communities.