Days in transition status for CurrentHierarchy member

How I can get dialy value for [Measures].[Days in transition status]?
My issue was 90 days in transition status “In progress”. that means if i get one day from this period, it will be 24 hours in progress for this day
how can i deal with it?

Hi @kvadrokopter

You may want to create a new calculated measure where you get minutes in transition status, and then set the formatting #hh #mm for the measure.
The formula for this measure would be the following:

[Measures].[Days in transition status]*24*60

You can read here how to define new measure:

Ilze ,

1 Like