This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
| 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?
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 |
|---|---|
| 33 | |
| 25 | |
| 23 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 64 | |
| 41 | |
| 27 | |
| 22 | |
| 20 |