Forum Discussion
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...
mickjaeger Need to confirm a couple things. You are creating a measure correct? [Scheduled Hours] is a measure? If [Schedule Hours] is a measure, what is the formula?
Greg_Deckler yes a measure indeed,
Scheduled Hours = SUM('scheduled_hours_fact'[roster_scheduled_time])