Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
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_ )
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
8 | |
8 | |
8 |