Sales function - apportioning weekly sales in days by Month

[Anonymous]

Hello,

 was workign on a visual and want a more accurate figure for Sales

I have 'week sales' in the table below which is pulling off a Excel document field

Now I do my week sales weekly - Mon-Sunday sales and do this every week - but I think that my sales could be overstated- is there any function or formula I can pull to take my sales in a week and only apportion them to that Month?

so for e.g. my sales week 29/1/24 to 4/2/24- I just want to pull Janaury figures so want to divide average this weeks sales and give 2 days to Janaury in the Visual below and the reamining 4 days to February 

[some_bih]

Hi @Anonymous to see Week number / week days in Calendar / Date table create columns, example on link.

After that simply slice, add to table matrix...