Forum Discussion

gpiero's avatar
gpiero
Skilled Sharer
10 years ago
Solved

Hard problem for a beginner

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.

 

Need Help
  • Sean's avatar
    Sean
    10 years ago

    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's avatar
    gpiero
    10 years ago

    Sean,

     

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

    :manvery-happy:

     

    gpiero

2 Replies

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    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's avatar
      gpiero
      Skilled Sharer
      10 years ago

      Sean,

       

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

      :manvery-happy:

       

      gpiero