Challenge Items

[xerikx]

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

[Ashish_Mathur]

Hi,

When you select 2021, do you want to show only those items which started and ended in 2021?

[xerikx]

Items where Date selected is between StartDate and EndDate. StarDate and EndDate format dd/mm/aaaa and date selected is mm-aaaa

[ryan_mayu]

@xerikx 

why the item is c not b?

[xerikx]

Sorry, is B 🤣

B because the date selected (2021 dic) is between StartDate and EndDate

[ryan_mayu · Accepted solution]

@xerikx 

pls see the attachment below