Forum Discussion
Growth Week on Week
Dear Experts,
i have a requirement to create week on week growth rate
below is how the table looks
Growth should be calculated based
(Current week GLobal Ter/Previous Week Global TER)-1
here is the sample data
https://drive.google.com/open?id=1udtnUgUku4T1UTKUyKVVXI9nonggwiya
then i need to make a visual like the below in power BI Desktop, its an example of Expected Output(based on Week on Week growth for Coloumn3)
also note that P8 Wk2(what you see in my data, is Wk of 10 Feb and so on for other periods and week
if anyone can do this in power BI desktop, can you please share pbix file as well?
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
9 Replies
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
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
