Forum Discussion

Joshua_'s avatar
Joshua_
Helper II
4 years ago
Solved

Get days worked between two dates

Hi Guys, I need to add a column that shows me the working day of the month, but starting and ending on a specific date, for example started Jan 10 and ending Jan 25 I tried to create...
Need Help
  • Joshua_'s avatar
    Joshua_
    4 years ago

    HI parry2k ,

    I created a second table containing the dates of the new table and connected it with my calendar table, then I got the business days (related function) and with the following formula I can do it.

    CALCULATE(
    SUM(CALENDARIO_CAMPANA[DIAS_HABILES]),
    FILTER(
    CALENDARIO_CAMPANA,
    CALENDARIO_CAMPANA[Date]<=EARLIER(CALENDARIO_CAMPANA[Date]) && CALENDARIO_CAMPANA[CAMPANA] = EARLIER(CALENDARIO_CAMPANA[CAMPANA])
    )
    )



     

     

parry2k's avatar
parry2k
Super User
4 years ago

Joshua_ all month start from 10 and ends at 25th? what's the logic?

 

 

Joshua_'s avatar
Joshua_
Helper II
4 years ago

Hi parry2k ,

It happens that I need to import a new table to the project and the dates of that data start and end on the 10th of every month, and I need to display the results based on the business days between those periods.

  • Joshua_'s avatar
    Joshua_
    Helper II
    4 years ago

    HI parry2k ,

    I created a second table containing the dates of the new table and connected it with my calendar table, then I got the business days (related function) and with the following formula I can do it.

    CALCULATE(
    SUM(CALENDARIO_CAMPANA[DIAS_HABILES]),
    FILTER(
    CALENDARIO_CAMPANA,
    CALENDARIO_CAMPANA[Date]<=EARLIER(CALENDARIO_CAMPANA[Date]) && CALENDARIO_CAMPANA[CAMPANA] = EARLIER(CALENDARIO_CAMPANA[CAMPANA])
    )
    )