Pulling in client name based on invoice number

[Andrewutter12]

Hello,

I have an "invoice" table" and a "debtors" table in PowerBI. I'm looking to pull in the client name from the debtors table to my invoice table based on my invoice number provided on my invoice table. Is there an easy/quick solution to make this happen?

Thanks!

[PhilipTreacy · Accepted solution]

Hi @Andrewutter12 

With a relationship between the tables you can add a calculated column in the Invoice table using

Client = RELATED(Debtors[Client])

to pull in the Client name.

Sample PBIX here.

regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[jthomson]

Assuming there's some sort of relationship between the two tables (i.e. on the invoice number), it should be automatic