Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey Everyone,
Background:
I'm pulling team sprint data from Jira cloud and want to show what stories the team completed within a sprint. This is easy to do when a story is completed within a single sprint since a single row is created. The problem I'm running into occurs when a story appears in multiple sprints because another row will be created. Except for the sprint field, this row will be identical to the other, including the completed date. This means that once a story is completed, it will appear as completed in every sprint it was in (see below).
Story # | Sprint | Completed Date
1 | 4 | 2018-11-15
1 | 5 | 2018-11-15
1 | 6 | 2018-11-15
Question:
To solve this I need to clear the completed date field so that it's null for every sprint other than the last sprint it appears in (see below).
Story # | Sprint | Completed Date
1 | 4 | null
1 | 5 | null
1 | 6 | 2018-11-15
Anyone know how to do this?
Thank you!
Solved! Go to Solution.
Hi @Anonymous,
You can add a calculated column.
Completeed Date2 = IF ( TB3[Sprint] = CALCULATE ( MAX ( TB3[Sprint] ), ALLEXCEPT ( TB3, TB3[Story] ) ), TB3[Completed Date], BLANK () )
Best regards,
Yuliana Gu
Hi @Anonymous,
You can add a calculated column.
Completeed Date2 = IF ( TB3[Sprint] = CALCULATE ( MAX ( TB3[Sprint] ), ALLEXCEPT ( TB3, TB3[Story] ) ), TB3[Completed Date], BLANK () )
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |