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,
I have a tabel with child_id and a lot of dates that the child is present. I would like to know how many kids are 1, 2, 3, 4, or 5 days per week present?
Tabel:
KIND_ID | DATE |
241777 | 1-8-2022 |
241777 | 2-8-2022 |
241777 | 8-8-2022 |
241777 | 9-8-2022 |
241777 | 15-8-2022 |
241777 | 16-8-2022 |
241777 | 22-8-2022 |
241777 | 23-8-2022 |
241777 | 29-8-2022 |
241777 | 30-8-2022 |
241777 | 5-9-2022 |
241777 | 6-9-2022 |
241777 | 12-9-2022 |
241777 | 13-9-2022 |
241777 | 19-9-2022 |
241777 | 20-9-2022 |
241777 | 26-9-2022 |
241777 | 27-9-2022 |
241777 | 3-10-2022 |
241777 | 4-10-2022 |
241777 | 10-10-2022 |
241777 | 11-10-2022 |
241777 | 17-10-2022 |
241777 | 18-10-2022 |
241777 | 24-10-2022 |
241777 | 25-10-2022 |
241777 | 31-10-2022 |
241777 | 1-11-2022 |
241777 | 7-11-2022 |
241777 | 14-11-2022 |
241777 | 15-11-2022 |
241777 | 21-11-2022 |
241777 | 22-11-2022 |
241777 | 28-11-2022 |
241777 | 29-11-2022 |
241777 | 5-12-2022 |
241777 | 6-12-2022 |
241777 | 12-12-2022 |
241777 | 13-12-2022 |
241777 | 19-12-2022 |
241777 | 20-12-2022 |
235927 | 1-8-2022 |
235927 | 2-8-2022 |
235927 | 3-8-2022 |
235927 | 4-8-2022 |
235927 | 5-8-2022 |
235927 | 8-8-2022 |
235927 | 9-8-2022 |
235927 | 10-8-2022 |
235927 | 11-8-2022 |
235927 | 12-8-2022 |
235927 | 15-8-2022 |
235927 | 16-8-2022 |
235927 | 17-8-2022 |
235927 | 18-8-2022 |
235927 | 19-8-2022 |
235927 | 22-8-2022 |
235927 | 23-8-2022 |
235927 | 24-8-2022 |
235927 | 25-8-2022 |
235927 | 26-8-2022 |
235927 | 29-8-2022 |
235927 | 30-8-2022 |
235927 | 31-8-2022 |
234936 | 1-8-2022 |
234936 | 8-8-2022 |
234936 | 15-8-2022 |
234936 | 22-8-2022 |
234936 | 29-8-2022 |
234936 | 5-9-2022 |
234936 | 12-9-2022 |
234936 | 19-9-2022 |
234936 | 26-9-2022 |
234936 | 3-10-2022 |
234936 | 10-10-2022 |
234936 | 17-10-2022 |
234936 | 24-10-2022 |
234936 | 31-10-2022 |
234936 | 7-11-2022 |
234936 | 14-11-2022 |
234936 | 21-11-2022 |
234936 | 28-11-2022 |
234936 | 5-12-2022 |
234936 | 12-12-2022 |
234936 | 19-12-2022 |
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thnx you, this really helps.
What I'm exactly looking for is: in week 42 there is
2% 1 day present,
80% is 2 days present,
16% is 3 days present,
1% is 4 days present,
1% is 5 days present.
Could you help me with that?
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you some much. This really worked.
You are welcome.
@Greg_Deckler thnx for your reply. I did add WEEKNUM and WEEKDAY column. The SUMMERIZE is not going well. Can you write it out for me?
@JoseHop Maybe something like this:
Measure 5 days =
VAR __Table = SUMMARIZE('Table',[KIND_ID],[WeekNum],"__Count",COUNTROWS(DISTINCT('Table'[Weekday)))
RETURN
COUNTROWS(FILTER(__Table,[__Count]=5))
@JoseHop Add a WEEKNUM column and a WEEKDAY column. Then you can SUMMARIZE by child and weeknum with a distinct count of weekdays.
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |