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.
Hi All,
I am hoping someone can help me. I am trying to create a measure to display on a card, that will calculate the total days spent on multiple tasks by multiple people within 'this' month.
So far I have the measure below, which is close, but totals the enitre duration of tasks that fit the criteria, i.e the start and end date fall within the parameters, however I only want it to include the days on task in 'this' month. Month being determined by a slicer / filter.
Ser | Event Type | Event Name | Start Date | End Date | Duration | Name |
1 | Task | A | 29/08/2022 | 16/12/2022 | 109 | Anne |
2 | Task | A | 29/08/2022 | 16/12/2022 | 109 | Brian |
3 | Task | A | 29/08/2022 | 16/12/2022 | 109 | Colin |
4 | Task | A | 29/08/2022 | 16/12/2022 | 109 | Dave |
5 | Task | A | 29/08/2022 | 16/12/2022 | 109 | Emma |
6 | Task | B | 10/10/2022 | 29/10/2022 | 19 | Farah |
7 | Task | B | 10/10/2022 | 29/10/2022 | 19 | George |
8 | Task | B | 10/10/2022 | 29/10/2022 | 19 | Hayley |
9 | Task | B | 10/10/2022 | 29/10/2022 | 19 | India |
10 | Task | B | 10/10/2022 | 29/10/2022 | 19 | Julie |
11 | Task | C | 15/09/2022 | 20/10/2022 | 35 | Kelly |
12 | Task | C | 15/09/2022 | 20/10/2022 | 35 | Liam |
13 | Task | C | 15/09/2022 | 20/10/2022 | 35 | Mike |
14 | Task | C | 15/09/2022 | 20/10/2022 | 35 | Natalie |
15 | Task | C | 15/09/2022 | 20/10/2022 | 35 | Oscar |
16 | Task | D | 25/10/2022 | 25/11/2022 | 31 | Pete |
17 | Task | D | 25/10/2022 | 25/11/2022 | 31 | Rachel |
18 | Task | D | 25/10/2022 | 25/11/2022 | 31 | Stef |
Solved! Go to Solution.
Hi @MORGANC846 ,
1) you have to create this snapshot table:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MORGANC846 ,
1) you have to create this snapshot table:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MORGANC846 ,
see my pbi file. Let me know if the link does not work.
https://1drv.ms/u/s!Aj45jbu0mDVJiyIF6BMMp6YfTJLq?e=82WjjQ
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for your reply, unfortuneately the link is restricted by my work security.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |