Forum Discussion
populate column based on different table
Hi all,
I have 2 tables, a customer/purchase table:
| customer | purchase |
| C1 | xyz |
| C1 | abc |
| C2 | xyz |
| C3 | edf |
and a table that lists premium customers
| customer |
| C1 |
| C3 |
I would like to add a calculated column to the customer/purchase table that reports (yes/no)
if the customer is a premium customer or not. Basically
| customer | purchase | Premium |
| C1 | xyz | yes |
| C1 | abc | yes |
| C2 | xyz | no |
| C3 | edf | yes |
|
Many thanks in advance
pls try this
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
1 Reply
pls try this
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.