Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |