Join 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!View all the Fabric Data Days sessions on demand. View schedule
| workitem id | state date change | sprint id(text format) | sprint start | sprint end |
| 12 | 22-01-2000 | sprint 2 | 21-01-2000 | 03-02-2000 |
| 10 | 21-01-2000 | sprint 2 | 21-01-2000 | 03-02-2000 |
| 12 | 05-01-2000 | sprint 0 | 23-12-1999 | 06-01-2000 |
| 13 | 08-01-2000 | sprint 1 | 07-01-2000 | 20-01-2000 |
| 11 | 07-01-2000 | sprint 1 | 07-01-2000 | 20-01-2000 |
| 13 | 06-01-2000 | sprint 0 | 23-12-1999 | 06-01-2000 |
| 202 | 21-01-2000 | sprint 2 | 21-01-2000 | 03-02-2000 |
| 223 | 23-01-2000 | sprint 2 | 21-01-2000 | 03-02-2000 |
| 223 | 06-01-2000 | sprint 0 | 23-12-1999 | 06-01-2000 |
| 203 | 20-01-2000 | sprint 1 | 07-01-2000 | 20-01-2000 |
here is my table ,i want to calculate the item only that are added to the sprint ON OR AFTER the second day OF THE SPRINT START....PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
you can use this logic if you want a calculated column. Then you can filter out the 0 from the end result.
if( int( sprint end - sprint start) >=2 , 1, 0 )
Please be more specific. Do you want this in Power Query or in DAX? What happens when you subtract the [sprint start] from the [state date change] value?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!