Weekly YOY Growth With One Day Per Week

[Silky_Johnson]

I am trying to create a measure that gives year over year change by week, but I can't use same period last year because the day is not the same each year. It is the Saturday of each week. 

Date	3/20/2004	3/27/2004	4/3/2004	4/10/2004	4/17/2004	4/24/2004	5/1/2004	5/8/2004	5/15/2004	5/22/2004	5/29/2004	6/5/2004	6/12/2004	6/19/2004	6/26/2004	7/3/2004	7/10/2004	7/17/2004	7/24/2004	7/31/2004	8/7/2004	8/14/2004	8/21/2004	8/28/2004	9/4/2004	9/11/2004	9/18/2004	9/25/2004	10/2/2004	10/9/2004	10/16/2004	10/23/2004	10/30/2004	11/6/2004	11/13/2004	11/20/2004	11/27/2004	12/4/2004	12/11/2004	12/18/2004	12/25/2004	1/1/2005	1/8/2005	1/15/2005	1/22/2005	1/29/2005	2/5/2005	2/12/2005	2/19/2005	2/26/2005	3/5/2005	3/12/2005	3/19/2005	3/26/2005	4/2/2005	4/9/2005	4/16/2005	4/23/2005	4/30/2005	5/7/2005	5/14/2005	5/21/2005	5/28/2005	6/4/2005	6/11/2005	6/18/2005	6/25/2005	7/2/2005	7/9/2005	7/16/2005	7/23/2005	7/30/2005	8/6/2005	8/13/2005	8/20/2005	8/27/2005	9/3/2005	9/10/2005	9/17/2005	9/24/2005	10/1/2005	10/8/2005	10/15/2005	10/22/2005	10/29/2005	11/5/2005	11/12/2005	11/19/2005	11/26/2005	12/3/2005	12/10/2005	12/17/2005	12/24/2005	12/31/2005	1/7/2006	1/14/2006	1/21/2006	1/28/2006	2/4/2006	2/11/2006	2/18/2006	2/25/2006	3/4/2006	3/11/2006	3/18/2006	3/25/2006	4/1/2006	4/8/2006	4/15/2006	4/22/2006	4/29/2006	5/6/2006	5/13/2006	5/20/2006	5/27/2006	6/3/2006	6/10/2006	6/17/2006	6/24/2006	7/1/2006	7/8/2006	7/15/2006	7/22/2006	7/29/2006	8/5/2006	8/12/2006	8/19/2006	8/26/2006	9/2/2006	9/9/2006	9/16/2006	9/23/2006	9/30/2006	10/7/2006	10/14/2006	10/21/2006	10/28/2006	11/4/2006	11/11/2006	11/18/2006	11/25/2006	12/2/2006	12/9/2006	12/16/2006	12/23/2006	12/30/2006
Item A	1,703,000	1,572,800	1,452,280	1,561,400	1,898,880	1,778,360	1,978,380	2,178,800	2,193,600	2,196,580	2,188,960	2,225,460	2,532,580	2,506,880	2,323,000	2,821,180	2,995,800	2,630,800	2,907,380	2,739,720	3,144,000	3,511,522	3,139,560	3,525,580	5,602,020	5,460,320	6,020,500	6,393,820	7,464,560	9,001,520	8,577,520	9,087,800	9,950,356	11,387,860	11,939,000	13,552,720	12,575,280	15,704,960	17,869,058	18,692,314	18,456,620	17,995,440	20,346,300	21,332,816	22,738,204	25,510,548	30,735,738	28,895,640	29,622,854	30,344,820	35,709,540	34,667,220	36,210,144	38,706,796	40,915,608	45,735,218	46,001,500	48,241,960	51,552,408	57,241,120	55,345,098	58,828,538	65,435,994	64,472,614	66,882,552	67,006,888	71,866,580	90,559,796	71,718,700	70,528,700	75,509,264	79,304,084	81,943,006	79,098,876	79,004,144	79,575,916	87,744,970	84,938,372	83,268,314	83,217,138	87,704,860	90,739,980	83,647,440	82,471,752	84,660,178	88,436,656	87,372,158	84,871,340	81,834,018	86,953,460	90,154,220	75,650,914	77,571,420	71,657,388	74,059,914	72,567,062	72,954,618	70,764,520	76,210,260	75,253,340	71,323,260	72,039,810	74,908,920	73,977,120	73,240,040	73,412,968	75,771,476	79,935,340	77,092,440	77,495,958	84,878,034	84,943,860	80,293,898	75,626,778	83,025,400	83,582,300	89,789,850	84,804,240	87,343,400	99,149,980	89,692,378	88,546,300	89,504,000	88,597,116	92,651,050	92,490,060	88,255,300	89,072,380	94,778,218	89,511,890	87,123,060	87,661,800	89,798,678	91,740,754	86,900,798	85,802,842	85,205,288	87,965,104	87,172,940	87,344,190	80,691,380	86,629,716	89,813,580	82,641,400	90,812,980	78,971,000
Item B	169,292,030	167,130,654	174,560,512	176,103,566	168,629,934	179,937,770	178,502,918	181,792,196	184,753,728	180,884,134	205,244,396	180,754,898	180,611,674	179,916,800	185,480,856	196,792,796	185,001,672	183,768,650	189,314,180	188,321,484	191,390,202	181,951,382	181,292,830	183,581,300	197,121,364	184,008,888	180,314,564	180,227,146	183,794,238	183,025,572	173,305,630	171,133,404	173,556,134	175,428,078	169,603,920	169,707,832	159,341,424	165,036,782	164,011,662	162,653,184	161,375,978	154,912,832	165,190,398	158,159,640	155,690,230	156,444,238	161,582,356	159,292,594	156,112,002	157,228,534	161,409,610	156,127,070	152,551,672	154,364,322	156,472,532	166,108,282	169,617,678	167,431,972	164,952,132	175,564,016	162,810,460	164,082,408	174,034,578	164,066,204	170,742,696	167,895,384	181,085,380	190,500,336	169,957,332	163,944,514	171,174,052	170,960,324	170,916,978	165,851,044	164,669,820	162,727,524	171,715,002	165,126,824	159,662,058	159,554,578	162,966,620	165,776,140	156,102,778	156,542,534	151,307,120	154,134,760	154,660,264	152,636,220	144,189,920	150,400,826	153,188,020	144,170,196	151,240,962	138,572,494	143,398,928	143,393,358	141,475,140	142,430,402	147,351,724	146,137,796	142,183,020	139,158,256	145,159,158	145,973,434	144,114,660	145,359,296	145,302,618	154,207,620	149,774,780	150,380,140	152,910,428	157,685,252	159,924,864	153,346,898	166,132,440	156,891,358	164,622,638	160,904,096	167,598,560	176,426,438	160,023,552	157,514,614	160,386,658	160,999,268	168,065,092	170,039,518	164,249,288	160,622,138	168,147,144	156,578,952	154,433,944	154,639,316	157,795,114	154,969,674	150,953,712	150,524,110	160,424,102	159,667,944	156,064,080	158,229,998	140,752,080	145,831,288	143,866,498	145,677,660	167,181,940	133,600,882

Result would looks like this. This is just a current entry divided by the entry 52 items ago.

Growth	3/19/2005	3/26/2005	4/2/2005	4/9/2005	4/16/2005	4/23/2005	4/30/2005	5/7/2005	5/14/2005	5/21/2005	5/28/2005	6/4/2005	6/11/2005	6/18/2005	6/25/2005	7/2/2005	7/9/2005	7/16/2005	7/23/2005	7/30/2005	8/6/2005	8/13/2005	8/20/2005	8/27/2005	9/3/2005	9/10/2005	9/17/2005	9/24/2005	10/1/2005	10/8/2005	10/15/2005	10/22/2005	10/29/2005	11/5/2005	11/12/2005	11/19/2005	11/26/2005	12/3/2005	12/10/2005	12/17/2005	12/24/2005	12/31/2005	1/7/2006	1/14/2006	1/21/2006	1/28/2006	2/4/2006	2/11/2006	2/18/2006	2/25/2006	3/4/2006	3/11/2006	3/18/2006	3/25/2006	4/1/2006	4/8/2006	4/15/2006	4/22/2006	4/29/2006	5/6/2006	5/13/2006	5/20/2006	5/27/2006	6/3/2006	6/10/2006	6/17/2006	6/24/2006	7/1/2006	7/8/2006	7/15/2006	7/22/2006	7/29/2006	8/5/2006	8/12/2006	8/19/2006	8/26/2006	9/2/2006	9/9/2006	9/16/2006	9/23/2006	9/30/2006	10/7/2006	10/14/2006	10/21/2006	10/28/2006	11/4/2006	11/11/2006	11/18/2006	11/25/2006	12/2/2006	12/9/2006	12/16/2006	12/23/2006	12/30/2006
Item A	2126%	2461%	2817%	2929%	2423%	2713%	2606%	2627%	2523%	2678%	2989%	2897%	2641%	2673%	3094%	3210%	2394%	2681%	2597%	2895%	2606%	2253%	2516%	2257%	1566%	1556%	1383%	1302%	1175%	1008%	975%	907%	851%	777%	732%	626%	651%	554%	505%	405%	420%	398%	364%	340%	321%	277%	248%	260%	241%	237%	210%	213%	202%	190%	185%	175%	168%	161%	165%	148%	145%	129%	127%	130%	134%	127%	122%	109%	125%	126%	119%	112%	113%	117%	112%	112%	108%	105%	105%	105%	102%	101%	104%	104%	101%	99%	100%	103%	99%	100%	100%	109%	117%	110%
Item B	90%	92%	90%	94%	101%	93%	92%	97%	88%	91%	85%	91%	95%	93%	98%	97%	92%	89%	90%	91%	89%	91%	91%	89%	87%	90%	89%	89%	89%	91%	90%	91%	87%	88%	91%	90%	90%	91%	93%	89%	94%	89%	87%	91%	91%	91%	91%	92%	91%	89%	90%	93%	94%	94%	93%	93%	88%	90%	93%	90%	98%	93%	95%	96%	96%	96%	93%	93%	94%	96%	94%	94%	98%	103%	100%	99%	98%	95%	97%	97%	97%	93%	97%	96%	106%	104%	101%	104%	98%	97%	94%	101%	111%	96%

Thank you!

[amitchandak]

Create a 364 days behind measure

364 days behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,day))

and take change % from the current measure. This will work fine as long as you group complete weeks

Hope you had date table and the report you have shown are matrix not measures created

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Silky_Johnson]

I actually do have this formula. But It doesn't work because of the 53rd week of the year. If I chart it, it goes like this 

Growth	12/30/2006
Item A	-100%
Item B	-100%

Instead of this

Growth	12/30/2006
Item A	10%
Item B	96%