Trying to Create BOOL Column Using Data From Other Tables

[jasonminhas]

My objective is to create three True/False columns in the account_table that identifies whether the account has purchased the "New", "Old" or both products based on the "Product Tag" column in the product_table. You can see I've written in the "Notes" column of the account_table what the customer purchased manually. How can I create a calculated column to do this?

account_table

product_table

sales_table

What I've tried:

I tried to use an if statement but the intellsense is not giving me the option to select the product_table. I also tried the CALCUATE function below to see if I can get it to return True for just accounts that ordered "Product A" but that was showing them all as True when it should've just been True for "Account ID" 100 since thats the only account that ordered "Product A".

CALCULATE(TRUE(),sales_table[Product ID]= "Product A")

[lbendlin]

You say boolean and then you mention three possible value (out of four) 🙂

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[jasonminhas · Accepted solution]

Hey Ibendlin, thanks for the feedback! I've reposted my question in the link below with additional clarity.

Trying to Create Column Using Data From Other Tabl... - Microsoft Power BI Community

[v-chenwuz-msft]

Hi @jasonminhas ,

Have your problem been solved, if yes, please mark it and others can find it quickly.

Best Regards

Community Support Team _ chenwu zhu