Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Missing Days

Hi I'm trying to calculate the number missing days. I have the below formula, however, I only want to calculate the days missing for a work week Monday - Friday. Any suggestions would be helpful.   ...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

Missing Days = CALCULATE(COUNTROWS('Work Date'), FILTER(Utilisation,[Total Recorded Time]<7) )

 

do you have a date dimension with the day of the week in it?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I'm looking for the current year