cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leopimenta Helper I
Helper I

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
Highlighted
Super User I
Super User I

Re: Daily and Weekly variance

This may help you:

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



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors