Forum Discussion

Anya_T's avatar
Anya_T
Frequent Visitor
5 years ago
Solved

Column Update

Hi,   I want to update a column, in which i want to get updated column with these condition Row User ID Manager Associate Expected  1 a Alpha b Beta 2 b Beta b Beta 3 c C...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anya_T ,

    Please update the formula of your calculated column [My Result] as below(the part with red font is new added):

    My Result =
    VAR _manager1 =
    MAXX (
    FILTER (
    'Table',
    'Table'[User ID] = EARLIER ( 'Table'[Associate] )
    && 'Table'[Row] = EARLIER ( 'Table'[Row] )
    ),
    'Table'[Manager]
    )
    VAR _manager2 =
    MAXX (
    FILTER ( 'Table', 'Table'[User ID] = EARLIER ( 'Table'[Associate] ) ),
    'Table'[Manager]
    )
    RETURN
    IF ( ISBLANK ( _manager1 ), _manager2, _manager1 )

    Best Regards

Anya_T's avatar
Anya_T
Frequent Visitor
5 years ago

Hi,

 

Is there any other way to do that?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anya_T ,

Please update the formula of your calculated column [My Result] as below(the part with red font is new added):

My Result =
VAR _manager1 =
MAXX (
FILTER (
'Table',
'Table'[User ID] = EARLIER ( 'Table'[Associate] )
&& 'Table'[Row] = EARLIER ( 'Table'[Row] )
),
'Table'[Manager]
)
VAR _manager2 =
MAXX (
FILTER ( 'Table', 'Table'[User ID] = EARLIER ( 'Table'[Associate] ) ),
'Table'[Manager]
)
RETURN
IF ( ISBLANK ( _manager1 ), _manager2, _manager1 )

Best Regards