Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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 |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
39 |