Forum Discussion
Counting days help me pls
Hello,
I need some help. I wrote the code:
counting without weekends =
VAR First = 'SQA list 2022'[End of Inspection]
VAR Last = 'SQA list 2022'[Delivered Report]
VAR First1 =
IF ( First <= Last, First, Last - 1 )
VAR Last1 =
IF ( First <= Last, Last, First1 )
RETURN
IF ( not isblank (first) && not isblank (last),
COUNTROWS (
FILTER (
ADDCOLUMNS ( CALENDAR ( First1, Last1 ), "Day of Week", WEEKDAY ( [Date], 2 ) ),
[Day of Week] <> 6
&& [Day of Week] <> 7
)
)
)
It is couting days from the End of Inspection Date, I want to count the days not from that day, but from next day. Can you help me?
Thank you 🙂
It is couting days from the End of Inspection Date, I want to count the days not from that day, but from next day. Can you help me?
Thank you 🙂
