Forum Discussion

KristianVangen's avatar
KristianVangen
Frequent Visitor
4 years ago

Get value from other table if

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 ...
Need Help
KristianVangen's avatar
KristianVangen
Frequent Visitor
4 years ago

Hi, thank you for replying! Sorry for the late response. I made an example with similar data. I want to show, among other things, how many responses I have recieved with the different messages. Something like this:

 

 

  • KristianVangen's avatar
    KristianVangen
    Frequent Visitor
    4 years ago

    To maybe simplify things a bit: What I need is how to create the relationship between the tables so that I can study when my respondents reply and to what message I sent out to them. Let's say I send out an email to 100 people, I get 60 responses within the two first days. I then send out a reminder to the remaining 40 people and 25 reply. I then close the possibility for replying on that particular topic. My result is in two tables:

    Type of emailNumber of people sent toDate
    Main1001. january 2022
    Reminder403. january 2022

     

    Respondent-IDDate reply
    11. january 2022
    21. january 2022
    32. january 2022
    ... 
    613. january 2022

     

    Every reply from 3rd of January is considered to be a reply to the reminder, not the first email (I know that is not certain, but that doesn't matter). So how do I combine these so that I can produce charts such as shown in the previous message?