Forum Discussion
DennisSchlein
Helper III
2 years agoAdd X network days to start date
Hi Im working on a forecast model, where I have a start date and a amount of working days to completion. Could be StartDate 18-04-2024 Exptected Task Working Days : 5 Would expect ...
Dangar332
Resident Rockstar
2 years agohi, DennisSchlein
Sorry for late reply i am working on it
Try below measure
result =
var a = CALENDAR(MIN('sample'[CMR_Close])+1,MIN('sample'[CMR_Close])+MIN('sample'[E2E])*2)
var b = ADDCOLUMNS(a,"week",IF(WEEKDAY([Date],2) in {6,7},0,1))
var c = ADDCOLUMNS(b,"rank",var c1=SUMX(FILTER(b,[Date]<=EARLIER([Date])),[week]) RETURN IF(WEEKDAY([Date],2) in {6,7},0,c1))
var d = MAXX(FILTER(c,[rank]=MIN('sample'[E2E])+0),[Date])
var e= CONCATENATEX(c,[rank]," , ",[Date])
RETURN
d
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.