This is one of the beautiful uses of "Compute Using." I have attached a mock-up using your data. Right-click on the table calculation and select "Edit Table Calculation" to see what I did. It was just changing one box.
Hope this helps,
Book1.twbx.zip 24.5 KB
Hello Brad, thanks a lot, your solution is working I slightly modified it - to show the most recent week on top - by changing "Display the value as a percent difference from" = "Next"
I have one more question - how can I do the % change calculation by creating a new Calculation Field instead of adding Table Calculation on an existing measure?
If I copy the calculation
(ZN(SUM([Pageviews])) - LOOKUP(ZN(SUM([Pageviews])), 1)) / ABS(LOOKUP(ZN(SUM([Pageviews])), 1))
= [TEST: % change] it does not work with the modified structure (=the most recent week on top). And it shows % change for the next line: