Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Column Showing Business days count between 2 dates

I have a table that has 'Created' date/time and 'Updated' date/time. I can calculate the DATEDIFF, but need to also show Business Days Only. I have a CalendarTbl[Date] with relationship to below da...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Something like this

    Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Created],Table[updated]),"WorkDay", if(not(WEEKDAY([Date],1) in {1,7}),1,0)),[WorkDay] =1))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Refer my Video on the same if that can help

https://www.youtube.com/watch?v=Qv4wT8_P-AA

 

Sample column formula

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Created],Table[updated]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))