Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi guys,
Good afternoon,
I have a new table that contains 1,000 new customers. However, it has no customer id that could link to other tables.
I need to filter my transaction table to show only the transactions made by these new 1,000 customers, how do I do it?
Thanks in advance.
Is the [Customer ID] field in 'New Customers' table in the 'Transaction' table?
What if you UNION the Customer and New Customer tables together?
Proud to be a Super User! | |
Thanks
The [Customer ID] is in the transaction table. No [customer id ] field in the new customer.
I made a workaround and don't know if there is a better solution. I created new columns for each table, merging the FirstName, LastName & DOB (my new unique identifier) then used lookupvalue to get the customer ID.
Hi @jchangco
Your workaround is good. Another option is to recreate relationships based on your new unique identifier column, but this would not be better than using customer ID column as you have done.
Best Regards,
Community Support Team _ Jing
User | Count |
---|---|
11 | |
8 | |
5 | |
5 | |
4 |
User | Count |
---|---|
16 | |
14 | |
8 | |
6 | |
6 |