Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi. I have data with 3 columns...ID, AlarmName, Date Created. I need to count how many times an AlarmName repeats within the last 15 days. Please help. Thanks!
Sample data:
ID | Date Created | AlarmName |
28910447 | 6/19/2021 | 1024OIAP01 |
28732964 | 6/15/2021 | 1024OIAP01 |
28729174 | 6/15/2021 | 1024OIAP01 |
28088366 | 5/31/2021 | 1024OIAP01 |
27895479 | 5/26/2021 | 1024OIAP01 |
27864540 | 5/25/2021 | 1024OIAP01 |
27772164 | 5/23/2021 | 1024OIAP01 |
27720929 | 5/21/2021 | 1024OIAP01 |
27388630 | 5/12/2021 | 1024OIAP01 |
27228304 | 5/7/2021 | 1024OIAP01 |
26966512 | 4/28/2021 | 1024OIAP01 |
26920784 | 4/27/2021 | 1024OIAP01 |
26783228 | 4/23/2021 | 1024OIAP01 |
Expected Result: | |
AlarmName | Count |
1024OIAP01 | 3 |
Solved! Go to Solution.
@The_Clam , Please try this with help from date table
Rolling 14 = CALCULATE(count(Table[ID]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date]),-14,DAY))
This will be for selected date or each date in trend
@The_Clam , Please try this with help from date table
Rolling 14 = CALCULATE(count(Table[ID]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date]),-14,DAY))
This will be for selected date or each date in trend
That worked! Thanks so much!
User | Count |
---|---|
79 | |
72 | |
71 | |
55 | |
51 |
User | Count |
---|---|
45 | |
38 | |
35 | |
31 | |
28 |