Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Adding up total workdays from a date filter

Hello,

 

I am trying to make a measure that would dynamically add up all of the values in my work day column using a date filters max and min values that I put into my report:

Let say we have a date column called Date and we also have a calculated column called WorkDay which pretty much assigns a 1 if the date column values are a workday else 0. The first thing I tried was to sum up all of the values in the WorkDay between MAX and MIN of the Date column but was not successful.

 

Can someone please help with this problem I am having cause I have tried other stuff and I am stumped.

 

Thanks

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      PattemManohar I don't have any trouble with finding working days at all but the problem is dynamically adding up the amount of workdays in between the date filter. I tried the methods in the post but things are still breaking and honestly I don't think the post is actually the answer to my problems. If I need to explain the problem better let me know.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    How did you do it for now? This could be simple like below.

     

    measure =
SUM ( 'DateTable'[IsWorkday] )

    If you'd like to ignore the slicer, try this one.

     

     

    measure =
CALCULATE (
    SUM ( 'DateTable'[IsWorkday] ),
    ALL ( 'DateTable'[cw_Dateofservice] )
)

     

    Best Regards,
    Dale