count no of days in a row having work days

[Anonymous]

Hello

I would like to calculate the days from the below workday list.

The result should be 5.

Thank you

Workdays

01-Jan-2023

03-Jan-2023

01-jan-2023

04-Jan-2023

04-Jan-2023

04-Jan-2023

05-Jan-2023

06-Jan-2023

06-Jan-2023

06-jan-2023

[Padycosmos]

Hope this helps:

[grantsamborn]

Hi @Anonymous 

I'm not sure how you arrive at a result of 5.

Since a) there was no "02-Jan-2023" and b) having a span of 6 days would include a weekend day, I would like you to explain your expected result of 5 workdays in a row.

(Edited to add:  Part b) is actually irrelevant since if there is 1 day off inside of any 6 day period, the maximum would be 4 days in a row - regardless of if they are working days or not.)

[bharanixem]

Hello grantsmborn

My requirement is to count no days and need to be excluded if the date is repeated. In the example if you consider 1-Jan-2023,3-Jan-2023,4-Jan-2023,5-jan-2023 ,6-Jan-2023 so total 5 days.

[grantsamborn · Accepted solution]

Hi @Anonymous 

I think I understand.

Would this help?

zCount = DISTINCTCOUNT( 'Workdays'[Workday] )

Let me know if I'm misunderstanding your post.

[Padycosmos]

Hope this helps:

[Andy1984]

@Anonymous 

I do not know your data set. for example you can try it with a measure like this:

count_workdays = NETWORKDAYS( DATE(2022,10,1), //start date

                                                          DATE(2022,10,31), //end date

                                                          7 )

Counts the days between the start date and end date, ignoring weekend days. 

7 = Friday and Saturday 

8 = Saturday and Sunday