Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
pls see the attachment below
Proud to be a Super User!
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
why the item is c not b?
Proud to be a Super User!
Sorry, is B 🤣
B because the date selected (2021 dic) is between StartDate and EndDate
pls see the attachment below
Proud to be a Super User!
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |