Weekly Count of Done Stories (not Running Total)

Questions & Answers
1

I have a Table with two columns, IssuesHistory – Complete (running total of completed stories) and IssuesHistory – All (running total of all stories in the data set), shown by week.

image
image1003×954 52.1 KB

These calculated measures are providing what I need for the current columns:

[Measures.IssuesHistory – Complete]
val(
([Measures].[Issues history],
[Transition Status.Category].[MOVE Complete2]) – Aggregated Complete Statuses
)

[Measures.IssuesHistory – All]
val(
([Measures].[Issues history],
[Transition Status.Category].[MOVE All Statuses]) – Aggregated All Statuses
)

However, I would also like to show the number of stories completed each week, like this:

image
image485×521 10.2 KB

I have tried tons of different ideas and have scoured the internet for hours, to no avail.

Can anyone point me in the right direction?

2

I finally figured it out!

I created the following calculated measure Weekly Difference

([Measures].[IssuesHistory - Complete],
 [Time].CurrentHierarchyMember.NextMember)
-
[Measures].[IssuesHistory - Complete]