Forum Discussion

FILIPKACZMAR's avatar
FILIPKACZMAR
Icon for Advocate I rankAdvocate I
3 years ago

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 🙂
DAX
DAX help needed

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Try

    Working days = NETWORKDAYS('SQA list 2022'[End of Inspection] + 1, 'SQA list 2022'[Delivered Report])