cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leopimenta Regular Visitor
Regular Visitor

Daily and Weekly variance

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 DateResultWeekNumberWeekDayDaily VarianceWeekly Variance
28/06/2019 00:00          158,197266                      860                           860
21/06/2019 00:00          157,337256                      323                        1,327
20/06/2019 00:00          157,015255                      516 
16/06/2019 00:01          156,498251                      488 
15/06/2019 00:00          156,010247-                    397                           190
10/06/2019 00:02          156,407242                      587 
05/06/2019 00:00          155,820234                  1,023                        1,023
01/06/2019 00:00          154,797227                      704                               -  
04/05/2019 00:00          154,093187              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.

 

Capture.PNG

 

I am also attaching the file.

DailyResult.pbix

 

Thanks a lot!!!

1 REPLY 1
Super User I
Super User I

Re: Daily and Weekly variance

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors