Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, like the title says I'm pretty stuck on a requirement levied for a customers employee disease tracking project.
Essentially, I would need to return a True\False value given the condition of:
>>if count_of_records >=5 then "true" else "false"
I'm using a sharepoint hosted list and the table is mirrored by the small table at the end of this post.
My plan was too..
1) First group all records by Store_ID
2) Once records are grouped by Store_ID, then group by Date_of_Infection
3) Count the records by Date_of_infection
4) Return true if count >= 5 else return false.
We can not use SQL, unfortunately, for this project an so I'm left trying to figure out how to translate those steps into a functioning series of dax measures or PowerM.
The end goal is to be able to identify "clusters" as defined by my customer where 5+ reported daily infections occur at a single site. For example, if 10 employees were sick this would generate 5 reporting_date & date_of_infection values. If 5+ values occured on the same day at the same store_id this would be a "cluster".
Any help is greatly appreciated an thank you very much in advance!
**In this table the rows with Store_id == 1 would return true, all others would return False.
Store_id | date_of_infection |
1 | 3-1-2021 |
1 | 3-1-2021 |
1 | 3-1-2021 |
1 | 3-1-2021 |
1 | 3-1-2021 |
2 | 3-2-2021 |
2 | 3-2-2021 |
Does this calculated column give you what you need?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |