Transition Author Calculated Field

We want to create a calculated field using the Transition Author. Here is an example:

[Transition Author].[User] in ( “IXXXXXX”,“IYYYYYY”)

can anyone help with this ?

Hi,

In that case, you could try creating a new calculated member in “Transition Author” dimension using the following code example:

Aggregate({
 [Transition Author].[User1 DisplayName],
 [Transition Author].[User2 DisplayName]
 })

Next, you could enable this calculated member from “Transition Author” dimension and then use in your report with some transition-related measure from “Measures” dimension

Martins / eazyBI support

1 Like