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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Jeffreyjar
Helper II
Helper II

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 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 CodesEAAGTNAME
A79901001ATSOL NDONGO NATHALIA
A19999062LIENOU GAYAP GHISLAINE
A39908001DITONE ARNAUD THEOPHILE
B49903001KENFACK DONFACK WILLIAM JOSPIN
A19999063ROMAY-BELL EDINGA ESSENGUE D

 

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

Numero AgentsNoms Agents
93003408KENFACK DONFACK WILLIAM JOSPIN
32699002ATSOL NDONGO NATHALIA
32599157ROMAY-BELL EDINGA ESSENGUE D
32599171LIENOU GAYAP GHISLAINE
32402304DITONE ARNAUD THEOPHILE
26499045FOTSO MEMO EPSE FOTSO C.
26499008MOYUE 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

1 ACCEPTED SOLUTION

@Jeffreyjar 

 

pls try with maxx

 

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

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

9 REPLIES 9
Jeffreyjar
Helper II
Helper II

Jeffreyjar_0-1656300428148.png

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

 

@Jeffreyjar 

 

pls try with maxx

 

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

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Jeffreyjar
Helper II
Helper II

Jeffreyjar_0-1656299165476.pngJeffreyjar_1-1656299211293.png

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

@Jeffreyjar 

could you pls provide your pbix file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Jeffreyjar
Helper II
Helper II

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

Numero AgentsNoms AgentsAgent New Code
93003406KENFACK VOUTSOP LEOPOLD GILDASB49903001
32699002ATSOL NDONGO NATHALIAA79901001
32599157ROMAY-BELL EDINGA ESSENGUE DA19999063
32599171LIENOU GAYAP GHISLAINEA19999062
32402304DITONE ARNAUD THEOPHILEA39908001

 

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

@Jeffreyjar 

pls try this

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

1.PNG

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Jeffreyjar
Helper II
Helper II

@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

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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