Forum Discussion

mickjaeger's avatar
mickjaeger
Helper I
4 years ago

Count Consecutive Days Worked

Hi Everyone, I don't get to work in DAX often enough and am still a newbie when it comes to creating advanced measures with DAX.     I have seen many, many proposed solutions out there for this sc...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

mickjaeger This would have been my solution:

DaysWith02 = 
    VAR __CurrentDate = MAX('Date'[date])
    VAR __CurrentHours = SUM('Hours'[roster_scheduled_time])
    VAR __LastBlank = MAXX(FILTER(ALL('Hours'),'Hours'[date]<=__CurrentDate && [roster_scheduled_time] = BLANK()),'Hours'[date])
RETURN (__CurrentDate - __LastBlank) * 1.