First Status in First day of Current Month

[guneycansanli]

I need to have a measure which is First Status in First day of Current Month.

[janis.plume]

Hi,
Please, check the formula provided here:

First Transition in First day of Current Month

Hi, The following formula finds the name of the status which had the earliest transition on the first day of the month: Filter( [Transition Status].[Transition Status].Members, (([Measures].[Transition to status first timestamp], [Time].[Day].Datemember('first day of month')) = ([Measures].[Transition to status first timestamp], [Transition Status].DefaultMember, [Time].[Day].Datemember('first day of month') ) ) ).Item(0).GetCaption If there will be no transition on that…

Kindly,
Janis, eazyBI support

[guneycansanli]

Thanks Janis It is working