[FONT="] I Have one table of calendar in the query simply dates. another table of projects and start date of the projects.[/FONT]
[FONT="]I wish to choose the project and then get in the calendar table another columns that compare the chosen project start date to the date in the calendar/ I could not find any way to do it. date diff doesn't not work with chosen from slicer[/FONT]
<tbody>
</tbody>[FONT="] [/FONT]
<tbody>
</tbody>
[FONT="]I wish to choose the project and then get in the calendar table another columns that compare the chosen project start date to the date in the calendar/ I could not find any way to do it. date diff doesn't not work with chosen from slicer[/FONT]
PROJ | date |
A | 13/01/2016 |
B | 19/01/2016 |
C | 04/01/2016 |
<tbody>
</tbody>
date | date diff from project |
01/01/2016 | |
02/01/2016 | |
03/01/2016 | |
04/01/2016 | |
05/01/2016 | |
06/01/2016 | |
07/01/2016 | |
08/01/2016 | |
09/01/2016 | |
10/01/2016 | |
11/01/2016 | |
12/01/2016 |
<tbody>
</tbody>