Forum Discussion
Solved
Challenge Items
Please community help me with the next challenge
My data
| Items | StartDate | EndDate |
| a | 20 Jan 2022 | 20 Feb 2022 |
| b | 30 Oct 2021 | 22 Feb 2022 |
| c | 30 Jul 2021 | 15 Nov 2021 |
Dashboard
Slicer: Selected 2021 Dic
Result: Table with Items worked with Slicer >= StartDate and Slicer =< EndDate . Example for slicer 2021 dic
| Items | StartDate | EndDate |
| b | 30 Oct 2021 | 22 Feb 2022 |
How can I do this
5 Replies
Hi,
When you select 2021, do you want to show only those items which started and ended in 2021?
Items where Date selected is between StartDate and EndDate. StarDate and EndDate format dd/mm/aaaa and date selected is mm-aaaa
