Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm not sure I'm asking the question correctly, but here it goes:
I have two tables. Table1 has these columns:
Client Name
Unique ID
Previous Year's Revenue
Table2 has:
Client Name
...and a bunch of other columns not relevant here
I am trying to pull the Unique ID and PY Revenue values from Table1 into Table2, by matching on Client Name. I can't quite figure out how to do this without throwing errors. And yes...I have to match on Client Name in this case. Help??
Solved! Go to Solution.
Hi:
Besides merging the two tables in Power Query you can try as calculated columns in Table 2.
Unique ID = LOOKUPVALUE(Table1[Unique ID], Table1[Client Name], Table2[Client Name])
and then rpeat same pattern for PY revenue.
PY Rev = LOOKUPVALUE(Table1[Previous Years Revenue], Table1[ClientName], Table2[ClientName])
I hope this solves this for you. Thanks
This did the trick, thank you!!
Hi:
Besides merging the two tables in Power Query you can try as calculated columns in Table 2.
Unique ID = LOOKUPVALUE(Table1[Unique ID], Table1[Client Name], Table2[Client Name])
and then rpeat same pattern for PY revenue.
PY Rev = LOOKUPVALUE(Table1[Previous Years Revenue], Table1[ClientName], Table2[ClientName])
I hope this solves this for you. Thanks
User | Count |
---|---|
50 | |
40 | |
18 | |
14 | |
13 |
User | Count |
---|---|
100 | |
63 | |
28 | |
18 | |
13 |