Forum Discussion
Growth Week on Week
vjnvinod , Please refer to my file, Where I am already doing that. Hope it helps
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
Yeah, that's going to be extra nasty because you have weird text weeks. I would recommend coming up with a sequential number for your weeks and then it is trivial. See these links:
This one compares a row with another "previous" row.
See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
And this is a Sequential number for weeks:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231#M116
if i rank my weeks,
let say P4 Week1 is 1
P4 Week2 is 2 and so on
can you tell me DAX formula to create a week on week measure
in Excel i have used below formula
(Current week GLobal Ter/Previous Week Global TER)-1
here is my data again
https://drive.google.com/open?id=1udtnUgUku4T1UTKUyKVVXI9nonggwiya