Forum Discussion
Solved
Value Repeating within Last 15 Days
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 |
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
2 Replies
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!
