Chart requests vs assignments per week

Hi  Dannyd20 ,

Here are the steps you can follow：

1. Create calculated table.

You can create a calendar table and use Week as the x-axis in the calendar table.

Table 2 =
CALENDAR(
    DATE(2023,7,1),
    DATE(2023,7,31))

Create calculated column.

Week = WEEKNUM('Table 2'[Date],2)

2. Create measure.

Logged_Measure =
COUNTX(
    FILTER(ALL('Table'),
    YEAR('Table'[Logged])=YEAR(MAX('Table 2'[Date]))&&WEEKNUM('Table'[Logged],2)=MAX('Table 2'[Week])),[Logged])

Assigned_Measure =
COUNTX(
    FILTER(ALL('Table'),
    YEAR('Table'[Assigned])=YEAR(MAX('Table 2'[Date]))&&WEEKNUM('Table'[Assigned],2)=MAX('Table 2'[Week])),[Assigned])

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly