Add workdays help

[jaltoft]

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?

[amitchandak · Accepted solution]

@jaltoft , I have blog on similar topic see if that can help

.Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...