Forum Discussion
Calculating Week on Week percentage change
Hi everyone,
How do I create a measure that shows the percentage change for the below table visualisation? What I want is an additional column that will show the percentage change between each week (whether minus or not), and I also want to conditionally format this column to display these positive or negative changes. Please advise me on how I can do this!
| Week Number | Net Revenue |
| 4 | £63,000 |
| 8 | £59,000 |
| 12 | £42,000 |
| 16 | £102,000 |
Thanks!
2 Replies
- amitchandak
Super User
Anonymous , based on you table try a measure like
diff Week vs Last week in table =
var _max = calculate(max(Table[Week]), filter(allselected(Table), Table[Week] <max(Table[Week])))
return
calculate(sum(Table[ Net Revenue])- calculate(sum(Table[ Net Revenue]),filter(allselected(Table), Table[Week] = _max))better Try with Week or week rank and week year /date table
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8 Hi Anonymous ,
Is your week number continuous? I saw your example jumped directly to the eighth week after the fourth week. How do you express the change in the middle? If possible, please complete the sample data and give your expected results.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
