The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
183 | |
80 | |
62 | |
46 | |
38 |