This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
| 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 May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 25 | |
| 24 | |
| 24 | |
| 14 |
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 27 | |
| 24 | |
| 19 |