Forum Discussion

Jeffreyjar's avatar
Jeffreyjar
Icon for Helper II rankHelper II
4 years ago
Solved

How can I update column with a new calculated column

Hello, Hello,    I'm kind of new in power bi so im doing small projects to perform myself,  im doing a ranking of each agents of a company and each agent has his own code and it is changing every...
General Comment
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Jeffreyjar 

     

    pls try with maxx

     

    Column = MAXX(FILTER('agent list','agent list'[EAAGTNAME]='APE 01 2022'[Noms Agents]),'agent list'[EAAGENT])

     

     

Jeffreyjar's avatar
Jeffreyjar
Icon for Helper II rankHelper II
4 years ago

ryan_mayu 

 

Sorry the expected output for the table APE february is 

 

Numero AgentsNoms Agents
B49903001KENFACK DONFACK WILLIAM JOSPIN
A79901001ATSOL NDONGO NATHALIA
A19999063ROMAY-BELL EDINGA ESSENGUE D
A19999062LIENOU GAYAP GHISLAINE
A39908001DITONE ARNAUD THEOPHILE
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

Jeffreyjar 

have you tried to use LOOKUPVALUE?

now I get the output,, however it is the same as the table you proivded in your first post. Could you pls provide the sample data?