Forum Discussion
Relational tables
Hi,
Thank you so much for contacting and wanting to help me. I hope the information i have provided below makes it a little easier. I have excluded some informantin for privacy reasons.
All tables include many different customers numbers.
DM vervegiro - This is first table which is at the beginning of the customer journey from a sent out direct mail. In this table, the campaign and campaign activities are the direct mail activity where memberships were generated. Payment date in this table, alerts us to the fact that this person wants to start their membership. Customer number and other sensitive information has been removed for privacy issues.
DM faddere 2018 hentet fra fadderskap – includes other information relevant to the customer’s membership. Including the person’s start date which should in theory be the same as the DM vervegiro - payment date.
DM faddere 2018 hentet fra kontakt table – Our organisation sends out a welcome pack to the customer to start the customer on a recurring payment plan. Then the customer returns the form, which we can see in the form received date. Then the next column needs to be taken from DM faddere 2018 hentet fra fadderskap. Nets_starts date.
DM faddere 2018 hentet fra donasjoner – mean all payments made from a customer’s subscription from the beginning of their existance. However, from the below table, I am after the payment was made since the nets_start date and any subsequent ones after that date. The problem is the campaign and campaign activities are sometimes the same or different to the ones in the DM vervegiro so I would need a (greater than) net:starts date to filter on to get than.
This is how it should be set up. I'm not to concerned about the time lapses but mainly to get this flow.
Thankyou again :)
Hi Anonymous
Thank you for sharing so many details.
For your requirement, i'm not very clear.
Also, it is complex of your data.
I'm stuck on making a test by these.
Based on my knowledge, to "include payment from the 8th of January 2018 to the 20th of Feb 2018",
you could create a measure like
Measure=calculate(sum('table name'[payment]),filter(all('table name'),[date]<=date(2018,2,20)&&[date]>=date(2018,1,8)))
Best Regards
Maggie
Hi Maggie,
Thank you for your input, much appreciated.
To clearify a bit:
I have four different spreadsheets and I want to create a flow with columns taken from each spreadsheet.
To make a simple example:
Let's say each spreadsheet has only 3 columns (A, B and C). I want to create a flow which would look like this:
1A-2B-1C-3A-4C-4B-1B-3B....etc
How do I set this up? The data-set reflects the different columns, but the question is how to create the flow here.
Best Regards,
Maria
Hi,
Also the time lapse isn't so relevant here in this first instance.
Thank you,
Maria