Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |