Hi,
I'm new to PowerBI and my brain usually in the Excel realm. I have two datasets which shows (1) each response to a message and (2) when the invite was sent. My ultimate goal is to be able to see when we have most success inviting people to respond with hypotheses like "it's best to invite on fridays", "we should wait longer between our reminders to get the answers we want" and so on. My date format is "dd.mm.yyyy hh.mm.ss"
Table 1
| Project | Costumer ID | Response date/time | Type of message |
| A | 1 | 01.01.2022 12:00 | Main Invite |
| A | 2 | 02.01.2022 13:00 | Main Invite |
| A | 3 | 5.01.2022 11:00 | Reminder 1 |
| B | 4 | 10.02.2022 10:00 | Main Invite |
| B | 5 | 14.02.2022 11:30 | Main Invite |
Table 2 - When invites/reminers are sent and number of people reached
| Project | Date | Type | Reach | Number of people responded within dates |
| A | 01.01.2022 15:00 | Main invite | 100 000 | 62 000 |
| A | 04.01.2022 12:00 | Reminder 1 | 38 000 | 15 000 |
| B | 08.01.2022 10:00 | Main invite | 50 000 | 25 000 |
Within Excel I would probably have added a column to table 1 stating what kind of invite/reminder the costumer responded to (most likely). Since the reminder goes out to all those who didn't respond, I would have made a column in table 2 showing how many responded because of the invite/reminder. I cannot seem to get how to add these columns based on what project it is and if the date of response is between dates in table 2.
Not even sure if this is a good idea so please help me understand!
