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

     

     

     

matus_jun's avatar
matus_jun
Frequent Visitor
1 year ago

How can i have date table that I can use with workday I create one but result I got is all 0

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

Make sure that there is no relationship between date and the workday column, Power BI can create relationships automatically. All you need the date table for in this case is to generate a list of dates which are not work days, for that you need a full calendar.