Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

conditional filtering help

Hi all,  I am trying to build a table of Net Working Days (or days worked) for a group of 9 team members. I am running into an interesting problem that needs a solution. You can see a snip of 3 tabl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Based on the description, please try the following dax formula:

Working Days = 
CALCULATE(
    SUM('US Days Worked'[US Workdays Per Month]) - COUNT('US Days Worked'[Date]),
    FILTER(
        'US Start End Date Logic',
        'US Start End Date Logic'[Value] = 1
    )
)

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.