The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I was hoping someone could help me figure out how to combine two columns from two different (related) tables in the following situation:
I have one table (personal) with personal data of subscribers to a magazine. This table contains an 'end date' with the date that the subscriber cancels their subscription. Hower, if a subscriber ends their subscription, they are called by the magazine the next day and receives a new offer that makes it appealing to stay a subscriber. If they accept this offer, the data of the subscriber is added to a second table (retention) in which the 'end date' is blank because they started a new contract.
Now i would like to combine these two tables so I can use the 'start date' from the personal table and the 'end date' from the retention table. However, I can't completely overwrite the 'end date' column in the personal table because there are people who won't accept the offer and their 'end date' in the personal table is final.
Can anyone tell me how to do this in the Query Editor?
Thanks so much in advance!
Solved! Go to Solution.
please see the attachment below
Proud to be a Super User!
please see the attachment below
Proud to be a Super User!