Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
102 | |
96 |