How can I update column with a new calculated column

[Jeffreyjar]

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 time  

I have an issue on matching 2 columns in different tables. One is up to date, the another one is old

Need help asap

the new column (calculated) is "New Agents Codes" of the table "agent list"

New Agents Codes	EAAGTNAME
A79901001	ATSOL NDONGO NATHALIA
A19999062	LIENOU GAYAP GHISLAINE
A39908001	DITONE ARNAUD THEOPHILE
B49903001	KENFACK DONFACK WILLIAM JOSPIN
A19999063	ROMAY-BELL EDINGA ESSENGUE D

the old column is "Numero Agents" of the table "APE February"

Numero Agents	Noms Agents
93003408	KENFACK DONFACK WILLIAM JOSPIN
32699002	ATSOL NDONGO NATHALIA
32599157	ROMAY-BELL EDINGA ESSENGUE D
32599171	LIENOU GAYAP GHISLAINE
32402304	DITONE ARNAUD THEOPHILE
26499045	FOTSO MEMO EPSE FOTSO C.
26499008	MOYUE FRANCOISE LADOUCE

NB: I need to match those new codes(numbers) of the table 'agent list' (it is up to date) with those old codes of the table 'APE february' , so that we could have a result of one column with updated columns  

kind regards

[Jeffreyjar]

@ryan_mayu can i transfer it to you by a different way?

[ryan_mayu · Accepted solution]

@Jeffreyjar 

pls try with maxx

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

[Jeffreyjar]

i've tried it already but returning no values @ryan_mayu 

[ryan_mayu]

@Jeffreyjar 

could you pls provide your pbix file?

[Jeffreyjar]

the expected output must be like this in ape february table, i've created a new column

Numero Agents	Noms Agents	Agent New Codes
93003406	KENFACK VOUTSOP LEOPOLD GILDAS	B49903001
32699002	ATSOL NDONGO NATHALIA	A79901001
32599157	ROMAY-BELL EDINGA ESSENGUE D	A19999063
32599171	LIENOU GAYAP GHISLAINE	A19999062
32402304	DITONE ARNAUD THEOPHILE	A39908001

However, i've tried to use lookupvalue

Agent New Code = LOOKUPVALUE('agent list'[New Agents Codes],'agent list'[EAAGTNAME],'APE 01 2022'[Noms Agents])

but it is not giving the result that i want

[ryan_mayu]

@Jeffreyjar 

pls try this

Column = LOOKUPVALUE('agent list'[New Agents Codes],'agent list'[EAAGTNAME],'APE February'[Noms Agents])

pls see the attachment below

[Jeffreyjar]

@ryan_mayu 

Sorry the expected output for the table APE february is 

Numero Agents	Noms Agents
B49903001	KENFACK DONFACK WILLIAM JOSPIN
A79901001	ATSOL NDONGO NATHALIA
A19999063	ROMAY-BELL EDINGA ESSENGUE D
A19999062	LIENOU GAYAP GHISLAINE
A39908001	DITONE ARNAUD THEOPHILE

[ryan_mayu]

@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?

[ryan_mayu]

@Jeffreyjar 

not clear about this. 

new column (calculated) , what's the DAX?

I can't see any column can match in table agent list and APE February.

Could you pls provide the expected output based on the sample data you provided?