Forum Discussion

matus_jun's avatar
matus_jun
Frequent Visitor
1 year ago
Solved

Count Consecutive from Work day

Hi how can I count Consecutive workday from workday as you can see 1 , 2 , 5  , 6 , 7 , 8 from column Workday. Consecutive workday should be 1,2 , 1,2,3,4  thank you for your help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi matus_jun ,

     

    Here is my test for your reference.

    Consecutive workday = 
VAR _minweek = WEEKNUM(MINX(ALL('WorkdayCalendar'[Date]),'WorkdayCalendar'[Date]),2)
VAR _interval = DATEDIFF(MINX(ALL('WorkdayCalendar'[Date]),'WorkdayCalendar'[Date]),MAX('WorkdayCalendar'[Date]),DAY)+1
VAR _weekday = WEEKDAY(MAX('WorkdayCalendar'[Date]),1)
RETURN
IF(WEEKNUM(MAX('WorkdayCalendar'[Date]),1)=_minweek,_interval,_weekday)

     

     

     

     

    Best regards,

    Mengmeng Li

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi matus_jun ,

 

Here is my test for your reference.

Consecutive workday = 
VAR _minweek = WEEKNUM(MINX(ALL('WorkdayCalendar'[Date]),'WorkdayCalendar'[Date]),2)
VAR _interval = DATEDIFF(MINX(ALL('WorkdayCalendar'[Date]),'WorkdayCalendar'[Date]),MAX('WorkdayCalendar'[Date]),DAY)+1
VAR _weekday = WEEKDAY(MAX('WorkdayCalendar'[Date]),1)
RETURN
IF(WEEKNUM(MAX('WorkdayCalendar'[Date]),1)=_minweek,_interval,_weekday)

 

 

 

 

Best regards,

Mengmeng Li