Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Week over week analysis of data

Hi everyone,

Currently  I am working on a project with power BI where I have to show week over week comparison of some data for a particular month.

 

The users upload the file once every week with a create date on sharepoint I need to show comparisons between different week of month .

 

Also if data stored is from Jan-June users can filter the records by month to see all four week of January and June.

Data -:

 

pattern   status.            Datecreated

ADFS.      Production.     04/02/2020

FMSSO.    In pipeline.      04/02/2020

 

::

ADFS.     Production.      05/02/2020

FMSSO.   In pipeline.      05/02/2020

1 ACCEPTED SOLUTION
4 REPLIES 4
amitchandak
Super User
Super User
Anonymous
Not applicable

Thanks everyone but I am still not getting it.

 

I did created the date table based on above blog post but how can I show all the week total in a given month.

 

I want something like in a given month we have four weeks 

so it should show 

 

Week1   Week 2   Week 3   Week 4 

 20          30            23           30

Show me a single month in the last ten years that had 4 weeks.

lbendlin
Super User
Super User

Weeks in a month?  Do you have a dates/calendar table that clearly spells out which week every single day is in?  "four weeks in a month" is only true for February if it is not a leap year and february 1st falls on a day that you identify as the start of the week. Meaning this happens extremely rarely.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.