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
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
To pile on what Greg_Deckler said, this is very easy to accomplish if you use dates and some basic time intelligence functions. Is it at all possible to translate P4 Week 1 into dates? Assuming that P4 refers to Period 4 which could be 4/1 through 4/30 (or whatever they are). You include the period and week numbers in the date table and this becomes rather simple to accomplish.