Board-related reports with multiple projects and multiple boards

[martins.vanags]

Hi @Mauro_Bennici

Perhaps you will find this post useful to calculate results for last closed sprints in the board.
Try exploring the calculated measure and how to adjust it for your report.

Filter your eazyBI for last 5 closed sprints

Hi This is an approach on how to filter the report for the last 5 closed sprints if you have other dimensions in pages which makes the report context. You could adjust the code to show more/less than 5 and also switch to show first sprints by changing the ordering conditions. First, you could create a new calculated measure (only to filter last 5 closed sprints sorted by sprint start dates) in your report using this code: Case when [Sprint].Currentmember.Level.Name = 'Sprint' Then Case whe…

Martins / eazyBI support team