Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anya_T
Frequent Visitor

Column Update

Hi,

 

I want to update a column, in which i want to get updated column with these condition

RowUser IDManagerAssociateExpected 
1aAlphabBeta
2bBetabBeta
3cCharliecCharlie
4dAlphadAlpha
5eAlphafGamma
6fGammafGamma
7gXetagXeta
8hBetahBeta
9iGammax 
10jCharliey 
11bAlphabAlpha

a) in Row 1 and 5, user id and associate are different but in expected column it is showing the result of manager belongs to associate not user id.

b) in row 9 and 10, user id and associate are not matching. Where as the associate value are unique not belong to any of the manager so it should show as blank

c) in row 11, the user id and assciate are worked under two different manager but still it should show the value of respective manager value.

 

Sharing the output i am getting

S. NoUser IDManagerAssociateMy Result

1

aAlphabBeta
2bBetabBeta
3cCharliecCharlie
4dAlphadAlpha
5eAlphafGamma
6fGammafGamma
7gXetagXeta
8hBetahBeta
9iGammax 
10jCharliey 
11bAlphabBeta

I am using this condition

My Result= MAXX(FILTER(table,table[User ID]= EARLIER(table[Associate])),table[Manager])

 

but in my row 11 it is showing the value of Beta which i want to be Alpha. The User ID is common for two different manager but still its printing the value of first one.

 

Please share some input.

 

Thank You

 

 

1 ACCEPTED SOLUTION

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 )

yingyinr_1-1629710498921.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anya_T , As per data user Id of 11 is b and Beta is max for that, That is why it showing beta

Hi,

 

Is there any other way to do that?

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 )

yingyinr_1-1629710498921.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.