Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |