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))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak 

Thank you Amit.  Your video was helpful and I will look at your other videos.  

 

One question... how would that Sample column formula work if Sunday=1 and Saturday=7?  

I am very new to DAX and just trying to learn as I go.

tks/

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much!  Worked great!