Allocating Weekly YouTube View Counts to Corresponding Months

Hi Experts,

I am encountering an issue with accurately calculating monthly YouTube views from data that is captured on a financial week basis. Our dataset does not include daily views; instead, views are aggregated weekly, which complicates month-end reporting when weeks span two different months.

Below is a snippet of the dataset for reference:

The challenge arises when financial weeks like Week 05 (29-Apr-24 to 5-May-24) and Week 09 (27-May-24 to 2-Jun-24) overlap between two months. Currently, our methodology does not split the view counts proportionally by the number of days in each month, leading to inaccuracies in monthly reporting.

Requirement: I need a method to correctly allocate view counts based on the number of days a financial week falls into each month. For example, for Week 05 from 29-Apr-24 to 5-May-24 with a view count of 21 for Madagascar:

• April should account for 2 days (29-Apr and 30-Apr). Therefore, the views for April would be calculated as follows: (2 days / 7 total days) * 21 views = 6 views.
• May should account for 5 days (1-May to 5-May). Therefore, the views for May would be calculated as follows: (5 days / 7 total days) * 21 views = 15 views.

So the expected numbers are below:

I have attached a PBIX for your reference. 
WeeklyViews.pbix
Anyone, Please help!!

Thank you,