Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi all,
I am looking to create a measure that will count the amount of values returned between two dates (1st Jan 2022 - 1st May 2022). However, I can't figure out the correct way. For something like a card it's easy as I can just add a relative time filter to the visual and it's done. But for say if I want a pie chart with the values between the dates mentioned above vs the values between another set of dates (2nd May 2022 - 2nd Aug 2022) I struggle to create the correct measure.
I've been toying around with this one:
Solved! Go to Solution.
You can specify a static date using the DATE function, e.g. DATE(2022,5,24).
Your syntax for combining filters is wrong, you don't need to specify the table again, so you could use
FILTER (
jiraissue,
jiraissue[CREATED] >= DATE ( 2022, 1, 1 )
&& jiraissue[CREATED] <= DATE ( 2022, 5, 1 )
)
I think you need and nor or for that condition so I changed it to && not ||
You can specify a static date using the DATE function, e.g. DATE(2022,5,24).
Your syntax for combining filters is wrong, you don't need to specify the table again, so you could use
FILTER (
jiraissue,
jiraissue[CREATED] >= DATE ( 2022, 1, 1 )
&& jiraissue[CREATED] <= DATE ( 2022, 5, 1 )
)
I think you need and nor or for that condition so I changed it to && not ||
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Check out the July 2026 Power BI update to learn about new features.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 30 | |
| 25 | |
| 25 | |
| 24 | |
| 16 |
| User | Count |
|---|---|
| 54 | |
| 37 | |
| 27 | |
| 24 | |
| 20 |