date difference

mina97 — Thu, 21 Sep 2023 06:54:25 GMT

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:11	28-05-2023 14:07:11	4

Re: date difference

ChiragGarg2512 — Thu, 21 Sep 2023 11:06:54 GMT

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.

topic Re: date difference in DAX Commands and Tips

date difference

Re: date difference