Daily and Weekly variance

[Anonymous]

Hello all.

I need a help.

I need to compare dailry result on a daily and weekly basis. The issue is that my source doesn't have data for all days, just the ones that had variances, as table example below.

Result Created Date	Result	WeekNumber	WeekDay	Daily Variance	Weekly Variance
28/06/2019 00:00	158,197	26	6	860	860
21/06/2019 00:00	157,337	25	6	323	1,327
20/06/2019 00:00	157,015	25	5	516
16/06/2019 00:01	156,498	25	1	488
15/06/2019 00:00	156,010	24	7	-                    397	190
10/06/2019 00:02	156,407	24	2	587
05/06/2019 00:00	155,820	23	4	1,023	1,023
01/06/2019 00:00	154,797	22	7	704	-
04/05/2019 00:00	154,093	18	7	154,093	-

For the daily variance, I could create it. But I am struggling with the weekly one. The measure that I did can't show the data for all weeks, as below.

I am also attaching the file.

DailyResult.pbix

Thanks a lot!!!

[SteveCampbell]

This may help you:

https://powerbi.tips/2019/07/the-dynamic-time-matrix/