Calculating Week on Week percentage change

[Anonymous]

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!

[Anonymous]

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.

[amitchandak]

@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