Forum Discussion

Anya_T's avatar
Anya_T
Frequent Visitor
5 years ago
Solved

Column Creation

Hi,   I want to create a new column, which should show the manager value. Sharing my expected column,   Associate Manager  Client Expected column a 1 b 2 b 2 b 2 c 3 c 3 ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anya_T 

    you can try this

    Column = maxx(FILTER('Table','Table'[Associate]=EARLIER('Table'[ Client])),'Table'[Manager])

Anya_T's avatar
Anya_T
Frequent Visitor
5 years ago

Hi, thank you for replying.

I tried but getting an error. How can i rectify it?

Sharing screenshot.

user_id= Associate

manager_id= Manager

Associate= ClientCreate Column

 

Fowmy's avatar
Fowmy
Super User
5 years ago

Anya_T 

 

There are  multiple values for one or more results, I assumed you had one record per match. 

it's your call. 

you can have a separate table for the combination without duplicates