Forum Discussion
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 hel...
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.
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.