Total Workdays in a month without breakdown

[Junaid11]

Hello,
I have got a formula which shows number of working days but if weekend it shows blank which is working fine and formula is given below:

WorkdayCount = IF(

    NOT(WEEKDAY(PBI_ARInvoices[InvoiceDate]) IN {1, 7}),

    RANKX(

        FILTER(

            PBI_ARInvoices,

            PBI_ARInvoices[Month NO] = EARLIER(PBI_ARInvoices[Month NO]) &&

            NOT(WEEKDAY(PBI_ARInvoices[InvoiceDate]) IN {1, 7})

            ),

        PBI_ARInvoices[InvoiceDate].[Date],

        , ASC, Dense))

Second formula is total monthly working days which is also given below:

MOnthly Working Days =

    COUNTX (

        FILTER (

            VALUES(PBI_ARInvoices[InvoiceDate]),

            WEEKDAY ( PBI_ARInvoices[InvoiceDate], 1 ) <> 1

                && WEEKDAY ( PBI_ARInvoices[InvoiceDate], 1 ) <> 7

        ),

        PBI_ARInvoices[InvoiceDate]

    )

I want to divide each working day with total monthly working days like if working day number today is 18 and October has 21 total working days then 18 divide by 21

but when I put them in table the total monthly number breakddoen like below :

I want outcome like below:

Date	Month	Day	Working Day NO	Monthly Working Day
08/09/2022	September	Thursday	6	22
08/09/2022	September	Thursday	6	22
12/09/2022	September	Monday	8	22
12/09/2022	September	Monday	8	22
22/09/2022	September	Thursday	16	22
24/09/2022	September	Saturday		22
25/09/2022	September	Sunday		22
25/09/2022	September	Sunday		22
28/09/2022	September	Wednesday	20	22
29/09/2022	September	Thursday	21	22
30/09/2022	September	Friday	22	22
11/10/2022	October	Tuesday	7	21

Kindly help me get updated formula without total monthly to breakdown.
Thank you

[Greg_Deckler · Accepted solution]

@Junaid11 Try this:

Monthly Working Days =
  VAR __Date = MAX(PBI_ARInvoices[InvoiceDate])
  VAR __Min = DATE(YEAR(__Date),MONTH(__Date),1)
  VAR __Max = EOMONTH(__Min,0)
RETURN
  NETWORKDAYS(__Min, __Max)