Forum Discussion

mickjaeger's avatar
mickjaeger
Icon for Helper I rankHelper I
5 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
Icon for Community Champion rankCommunity Champion
5 years ago

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?

mickjaeger's avatar
mickjaeger
Icon for Helper I rankHelper I
5 years ago

Greg_Deckler yes a measure indeed, 

 

Scheduled Hours = SUM('scheduled_hours_fact'[roster_scheduled_time])