No Excel file attached
I would suggest creating a parameter for the date selection and then a calculated field to do the relative date calculation.
There's still no file attached
1 of 1 people found this helpful
There are couple of ways to solve this, but the easiest way would be to reshape your data such that you only have one row per Date field. This can be achieved either with the help of Custom SQL or you can do the UNION.
Current Date format:
Changed Date format:
The other options which are there are Pivot the data, Data Scaffolding and Data Blending but the option which i have mentioned above will keep the data structure simple.
Hope this helps.