Create calculated column based on info in another table

[Anonymous]

Hey everyone,

I have two related tables, one with person's information another with all transactions for all people. The tables have the following structure:
 
Person's Info

Name	Country	Address
Michael	Poland	Address 1
Max	Spain	Address 2
Mona	Croatia	Address 3

Transaction Info

Name	Bought from	Date
Michael	Amazon	01.01.2020
Michael	Coffeeshop	01.02.2020
Max	Amazon	01.01.2020
Max	eBay	01.01.2020

I want to add a conditional column "Drinks coffee" to the "Person's info" table which will say "Yes" if a person bought from "Coffeeshop" at any date, otherwise "No". [So, in this example Michael will have "Yes", Max and Mona will have "No"]

Thank you in advance!

[Anonymous]

Hi,

I am not sure how to do this on DAX. But you can merge tables in Power Query and then create a conditionnal column.

Good day

[AlB · Accepted solution]

Hi @Anonymous 

If you have a relationship through "Name":

New Column =
IF (
    CALCULATE (
        COUNT ( TransactionT[Name] ),
        TransactionT[Bought from] = "Coffeeshop"
    ) > 0,
    "Yes",
    "No"
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers