Forum Discussion
Measure for Datesbetween
Hi, I need to create a measure to understand the Lead time (total days between 2 dates in the same table excluding Saturday and Sunday) My table name is Open Orders and below are the 2 date ...
vjnvinod , I think you need workdays
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[Open on],Table[Requested Delivery Date]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))
How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA
was trying to replicate it
i think something is wrong, after the calendar function, it doesn't read the date column
