I'd approach this by creating a parameter where the user can enter/choose the date, then create a calculated field using a DATEDIFF between your parameter and the date dimension, then put that on the filter shelf and make the range 0-14.
This can be done in three simple steps. I have attached workbook also for your better understanding.
1) Create Select Date parameter.
2) Create calculated field Flag
DATEDIFF('day',[Order Date],[Select Date])>0 AND
DATEDIFF('day',[Order Date],[Select Date])<=14
3) Use this calculated field as Filter selected True.
Pretty much exactly what I said, but I wouldn't hard-code the values in the calculated field because then you can expose the filter to the user and they can choose the number of days.
Hello Chris, i am struggling how would you say that this calculated field can be change by final user?
You can't with your calculation because the 14 is hard-coded into the calculation.
If you just did
DATEDIFF('day', [Order Date], [Select Date])
then it's a numeric result that the end-user can change (if required)
But, i think the requirement is Order Date = Select Date + 14?
" From the entered date, report should only show data for next 14 days i.e if user enter 06-08-2017 then report should show data from 06-08-2017 to 06-22-2017."