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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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?