Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |