Forum Discussion
Helper IIHow 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 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
pls try with maxx
Column = MAXX(FILTER('agent list','agent list'[EAAGTNAME]='APE 01 2022'[Noms Agents]),'agent list'[EAAGENT])
9 Replies
ryan_mayuSuper User
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?
JeffreyjarSorry 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
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?
- 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
pls try this
Column = LOOKUPVALUE('agent list'[New Agents Codes],'agent list'[EAAGTNAME],'APE February'[Noms Agents])pls see the attachment below
- Jeffreyjar
i've tried it already but returning no values ryan_mayu
- ryan_mayu
could you pls provide your pbix file?
- Jeffreyjar
- ryan_mayu
pls try with maxx
Column = MAXX(FILTER('agent list','agent list'[EAAGTNAME]='APE 01 2022'[Noms Agents]),'agent list'[EAAGENT])