The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
53 | |
31 | |
30 | |
23 | |
21 |