Adding up total workdays from a date filter

[Anonymous]

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

[v-jiascu-msft]

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

[PattemManohar]

@Anonymous I'd recommed you this link to solve this.

https://community.powerbi.com/t5/Desktop/working-day-total-working-day-running-total/td-p/195077

[Anonymous]

@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.