Forum Discussion

jaltoft's avatar
jaltoft
Resolver I
5 years ago
Solved

Add workdays help

Hello,

 

I have an existing query that works fine as to what its doing currently but I want to modify it -

IF(AND('Visit timescale'[Custom category]="CIN",'Visit timescale'[Eligible for visit ="N")&&'Visit timescale'[Date of last Visit]<>BLANK(),CONVERT
(CALCULATE(
COUNTROWS ('DimDate'),
DATESBETWEEN (DimDate[Date],'Visit timescale'[Date of last Visit], 'Visit timescale'[ReportWeekSunday]),
DimDate[Workday] = 1,
ALL ('Visit timescale')),STRING)
 
The highlighted part of my formulae is working out a count of the dates if dimdate is workday between two dates within table 1 (My data) and the dimdate calendar I have. (This has workdays flagged as 1 and weekends and bank holidays flagged as 0)
I want to return the date in my calculated column rather than a column of the days between each? How can I do this? So I want to return date of last visit plus 5 working days as a date dd/mm/yyyy?
Need Help