DAX Calculation to count number of working days based on weekend date for current month to date

[bhaskarpbi999]

Hi ,

There is a DWH fact table  where revenue and volume for current year and previous years  is stored but for current month data is loaded on weekly basis and we only need DAX logic for current month.

For example, We are in Feb'25 and as of now data is  loaded data up to last week 8th Feb'25 Weekend date which is saturday.

so i need the DAX calcualtion to count the number of working days for only current month based on weekend date up to 8th Feb excluding saturday and sundays and the expected result should be 5 days.

        if  Data loaded up to 8th Feb'25 -   result  should be 5 working days

        if Data loaded up to 15th Feb'25 - result  Should be 10 working days

        if Data loaded up to 22nd Feb,25 - result should be 15 working days.

Data sample in DWH table like below.

Could you please help me to write the DAX formula for above scenario.

Thanks in Advance.

Regards,

Bhaskar

[Anonymous · Accepted solution]

Hi @bhaskarpbi999 ,

You can set variables to get the current year and month, and then set the day to 1 as the beginning of the current month, which is also the start date.

Here is my test for your reference.

weekdays = VAR _maxyear = YEAR(MAX('Table'[Weekend Date]))
VAR _maxmonth = MONTH(MAX('Table'[Weekend Date]))
RETURN
NETWORKDAYS(DATE(_maxyear,_maxmonth,1),MAX('Table'[Weekend Date]))

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[Anonymous · Accepted solution]

Hi @bhaskarpbi999 ,

You can set variables to get the current year and month, and then set the day to 1 as the beginning of the current month, which is also the start date.

Here is my test for your reference.

weekdays = VAR _maxyear = YEAR(MAX('Table'[Weekend Date]))
VAR _maxmonth = MONTH(MAX('Table'[Weekend Date]))
RETURN
NETWORKDAYS(DATE(_maxyear,_maxmonth,1),MAX('Table'[Weekend Date]))

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[bhaskarpbi999 · Accepted solution]

Hi Mengmeng,

Thanks and kudos to your support.

I will try the above solution and will keep you posted many thanks for the support.

Thanks 

Bhaskat

[parry2k]

@bhaskarpbi999 have you tried the DAX NetworkDays function?  NETWORKDAYS function (DAX) - DAX | Microsoft Learn

[bhaskarpbi999]

Hi Parry,

Thanks for your extremed support.

I have only weekend date in my DWH table and for the network days functionwe need start date and end date.

Could you please help if there is any alternative solution for the above scenario.

Thanks in Advance.

Regards,

Bhaska