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 some data in the following format:
Incident Number | Date Occurred | Incident Name |
143 | 1/1/2001 12:00 | ex 1 |
361 | 1/2/2001 14:00 | ex 2 |
I am trying to count the number of incidents that have a [Date Occurred] within a certain time frame relative to the current date. I want the number of incidents with a [Date Occurred] between 7 days ago after 12:00 PM to today before 12:00 PM.
To give an example: if it is Thursday today, I would like to count the number of incidents with a [Date Occurred] between LAST thursday after 12:00 PM and 12:00 PM this Thursday (today).
Ideally, I would like a measure to get this count.
Thanks!
Hi @Anonymous
Try this measure in a card visual:
Measure = VAR Today12_ = TODAY () + ( 12 / 24 ) //Add 12 hours VAR Beginning_ = Today12_ - 7 // Subtract 7 days RETURN CALCULATE ( COUNTROWS ( Table1 ), Table1[Date Occurred] >= Beginning_, Table1[Date Occurred] < Today12_ )
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
32 | |
30 | |
18 | |
18 |