Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Solved! Go to Solution.
pls try with maxx
Column = MAXX(FILTER('agent list','agent list'[EAAGTNAME]='APE 01 2022'[Noms Agents]),'agent list'[EAAGENT])
Proud to be a Super User!
pls try with maxx
Column = MAXX(FILTER('agent list','agent list'[EAAGTNAME]='APE 01 2022'[Noms Agents]),'agent list'[EAAGENT])
Proud to be a Super User!
could you pls provide your pbix file?
Proud to be a Super User!
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
pls try this
Column = LOOKUPVALUE('agent list'[New Agents Codes],'agent list'[EAAGTNAME],'APE February'[Noms Agents])
pls see the attachment below
Proud to be a Super User!
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 |
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?
Proud to be a Super 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?
Proud to be a Super User!
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |