Need some help with working days/calcs in calendar table

[Anonymous]

Afternoon all - I'm hoping someone can offer me a possible solution to this problem.  

I have a calendar table in my model to which I have added a number of calcualted columns to calculate 10/20 etc working days in the future from the date in the 'Dates' field. This is in turn based on an 'Index' column which is calculating against 'Is Working Day' being 'Yes' (I appreciate this is where my problem is coming from).

This works fine where the row value in 'Dates' is a working day but returns spurious results where the value in 'Dates' is a weekend (it basically counts the number of days from the start date in the calendar table, 1st April 2018.

I need my calculated columns that return the x number of working days in the future to perform as is for weekdays, but for Saturdays/Sundays to then allocate the correct 10/20 etc WDs in the future (as I say I appreciated my issue is with the Index column and how I have performed the filter but not sure how to correct).

Any assistance rendered and received would be hugely appreciated.

Cheers

Ian

[amitchandak]

@Anonymous , I have create a blog on similar problem, check 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-Calendar-4-5-Power/ba-p/1187766