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

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