Hard problem for a beginner

[gpiero]

I have a table which contain the following columns

I woulld like to calculate the number  of the working days between those days.

I have created a table where  I have defined my calendar according to local Holidays.

The last column contain a logical value that define how to consider that date.

But to be honest I am not able to find a simple way to do it.

Is there a simple solution for a beginner?

Thanks in advance for your help.

[Sean · Accepted solution]

@gpiero Try this... Let me know if it works.

Column =
CALCULATE (
    COUNTROWS ( 'Calendar Table' ),
    ALL ( 'Calendar Table' ),
    DATESBETWEEN ( 'Calendar Table'[Date], Table[Start Date], Table[End Date] ),
    'Calendar Table'[IsWorkingDay] = "Y"
)

[Sean · Accepted solution]

@gpiero Try this... Let me know if it works.

Column =
CALCULATE (
    COUNTROWS ( 'Calendar Table' ),
    ALL ( 'Calendar Table' ),
    DATESBETWEEN ( 'Calendar Table'[Date], Table[Start Date], Table[End Date] ),
    'Calendar Table'[IsWorkingDay] = "Y"
)

[gpiero · Accepted solution]

@Sean,

Many thanks. Your solution work perfectly and I have more opportunity to apply it again.

gpiero