Forum Discussion

mina97's avatar
mina97
Helper III
2 years ago
Solved

date difference

i have the following data 

i want the to exclude friday and saturday also o want to exclude the start date and start counting from the next day
so want to show the date diff as 3 not 4 

please help and thank you  
i wrote in date the following 

 

workdays = 

var TBL_DATE=CALENDAR(sheet[start date],sheet{end date])
var TBL_FINALDATE= ADDCOLUMNS(TBL_DATE,"WorkingDate",IF(WEEKDAY([Date],2)>=6,0,1))
return
SUMX(TBL_FINALDATE,IF([WorkingDate]=1,1,0))​

 

 
this is how it looks now 


start date end date date diff
23-05-2023 10:07:1128-05-2023 14:07:114
Data Analysis
Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    Currently, the dax expression is marking saturday and sunday as 0 rather than friday and saturday. For, friday and saturday change WEEKDAY([Date], 2) to WEEKDAY([Date], 1). This will mark friday as 6 and saturday as 7 instead of marking friday as 5, saturday as 6 and sunday as 7.

     

    Also, if one day has to be removed every time remove 1 from the total sum.

1 Reply

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Currently, the dax expression is marking saturday and sunday as 0 rather than friday and saturday. For, friday and saturday change WEEKDAY([Date], 2) to WEEKDAY([Date], 1). This will mark friday as 6 and saturday as 7 instead of marking friday as 5, saturday as 6 and sunday as 7.

     

    Also, if one day has to be removed every time remove 1 from the total sum.