I’m trying to create a report which shows the monthly Uptime % over the past 12 months, using the correct number of minutes in each month. I’ve created 3 measures that calculate the Uptime based on a month with 28/30/31 days (i.e. ((43200-[Measures].[Downtime in Minutes])/43200)*100), but what I ideally want is a report that works out how many days there are in a given month and make the calculation on that basis for that month. This is what I’ve done, but obviously don’t want the report to show the Uptime % that is not relevant to that month
Try this code when creating a new user-defined calculated measure to return days in a displayed month for report rows
Datediffdays(
[Time].CurrentHierarchyMember.StartDate,
[Time].CurrentHierarchyMember.NextStartDate
)
I guess that would let you keep just one column in your report for Uptime calculations
Martins / eazyBI team
1 Like