This seems so basic but it's getting the best of me. I'm trying to track conversions on all our marketing contact forms against our internal new patient records. The only field to compare unfortunately is name (which I realise will have a margin of error). I can't seem to link these values relationship wise so I was thinking a lookup could potentially work. Any assistance would be greatly appreciated. Thanks.
Hi @peekayza ,
In this situation I would create a table that has all the Name values from the other tables (which would be your lookup table or dimension table), de-duplicated. Then you can join that to the other tables (New Patients, SS Contact Form, GDC Contact Form).
Modeling -> New Table:
Make sure it's 1:Many from Names to the other tables.
Here I can see of the 25 people in Fact 1, only 1 is in Fact 2, or 4% of Fact 1.
I've attached a PBIX with this set up for you to look at.
Hope this helps!
See my reports and blog at https://www.datazoepowerbi.com/
Thank you so much! I will look at this right away and report back soonest. Does it make a difference that my name field is both first and last name combined?
Thanks again for your help and patience. So I think I took it a slightly different approach to you. I am wanting to check conversions per brand (TDIC, GDC and SS) against the new patients table names.
So as first step I've managed to merge all the GDC names into a single conversions table with names. What I am struggling with is the next step of comparing it against the new patient names. I just can't see any easy way to bring the name in from that table. I tried this step below. Any assistance would be appreciated thanks.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!