Multiple criteria filter - Multiple tables

[HE]

Hello, 

I would like to have some help please.

To explain the contexte, I have 2 tables "Months" where I have my Data & "Stat" where I increment the data without taking the weekend in concideration. I would like to add a 3rd table to manage the holidays.

In my "Stat" I do calculation based on the weekdays. So far to increase my CA values I added a calculated column to exclude the weekends and used this info to increment my CA.

• Weekdays = if((weekday(‘Stat’[Calendar day])<>1 && weekday(‘Stat’[Calendar day])<>7),"True","False")

And after that i added a measure to calculate and increment my values using this formula: 

• CA Inc = Calculate(sum('Month'[CA]),filter(filter(all(Stat),Stat[Weekdays]="True"),Stat[Calendar day]<=Max(Stat[Calendar day])))

I have been looking on how I can add another filter so whenever I have a date in my holidays table, to be able to exclude this date and not increment the values. (the picture showing an example) 

Thank you so much for your help.

[lbendlin · Accepted solution]

It would be much simpler if you would use a common calendar table with a column "Include this day"  that you can then set according to your rules, and then use as a filter in your computations. That would take care of all weekend days and holidays etc.