Display card visual for worked days and remaining working days in current month

[Karthik12]

Hello Team,

I need to display in power bi report for no of working days passed so far and remaining working days of current month

i,e todays is 17.11.2022 means, 15 days worked days (except sunday) and 12 days are remaining working days (except sunday)

may I know , How can I visualize in the card in power bi report?

[Anonymous · Accepted solution]

Hi @Karthik12 ,

Check the formulas:

worked days = 
var startday = EOMONTH(TODAY(),-1)+1
return
NETWORKDAYS(startday,TODAY(),11)

remaining working days = 
var endday = EOMONTH(TODAY(),0)
return
NETWORKDAYS(TODAY()+1,endday,11)

[Karthik12]

Thanks @Anonymous 

It is working fine. I have accepted this solution.

In other case,

We have following fical year calender (4-4-5) which means Start and end date of month is not always 1 and 31. For example, as per our fical year calender Dec month started on 26th Nov 2022 and ending 31st Dec.

Is it possible to have calculate working days and remaining days between two dates?

Thanks in advance for your support.

[Karthik12]

@amitchandak 

Thanks for the support. 

I have tried the same. But, it looks numbers are not matching.

Actually, worked day till yesterday is 14 and remaining days from today is 12 (if we exclude sundays)

Can you please check and support further?

[Karthik12]

@amitchandak Hi,

Can you please support? 

[amitchandak]

@Karthik12 , New column or measure

Work day in month till date =

networkdays(eomonth(today(),-1)+1, today(), 1)

remaining Work day in month till date =

networkdays(today()+1, eomonth(Today(),0) , 1)

Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c

https://amitchandak.medium.com/power-bi-dax-function-networkdays-5c8e4aca38c

[Ciotti]

Thank you for the above, helped me out.

is there a way to use networkdays to display the total working days for the current month based on the day before?

if today was the 01/11/2024 then it would still show 23 total networkdays for the month of October 

Thanks

[Ashish_Mathur]

Hi,

Read this article - NETWORKDAYS function (DAX) - DAX | Microsoft Learn