Need Help with Relationship Editor

[Muniba]

Hello I have three datasets representing short-term, long-term, and mid-term churn. Each dataset contains the same columns: date, reason, and plan. I want to create a combined summary of all the data, but I'm struggling to establish the relationship between the date formats. I've successfully created relationships based on the plan type so that selecting any specific plan interacts with all three datasets. However, when I try to do the same for the date, it's not working. How can I overcome this challenge? Also, is there a way to activate both relationships simultaneously? Additionally, please note that the date format is the same across all datasets. Any assistance or suggestions to resolve this would be greatly appreciated.

[PijushRoy · Accepted solution]

Hi @Muniba 

Use Power Query editor (if you are not using Live connection or Direct Mode) and Append Query as New to create a new combined table.

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin