Forum Discussion

milkmoneymike's avatar
milkmoneymike
Icon for Helper I rankHelper I
6 years ago
Solved

Help with Conference attendee data

Hello All
Im pretty new to Power BI and had some questions about a report i am working on, Hopefully this makes sense and is doable. I have the Powe BI file HERE. If it will help with creating this request. Many thanks to anyone who can point me in the right direction. i would like a Count of contact IDs for each show (which i can easily do) but im having issues with these:

  • I want to show number of first timers (People who have never been to ANY previous show)
  • For the people who have been to a previous confernce how can i show what confernces they HAVE been to?

Thank You 

MM

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Create a new columns.

    This will count a person appears in any show. You are looking for 1

    Times in any show = countx(FILTER(data,data[contactid]=EARLIER(data[contactid]) && data[StartDate]<=EARLIER(data[StartDate])),data[contactid])

    In a show how many time

    timeS in that show = countx(FILTER(data,data[contactid]=EARLIER(data[contactid]) && data[EventName]=EARLIER(data[EventName]) && data[StartDate]<=EARLIER(data[StartDate])),data[contactid])

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Create a new columns.

    This will count a person appears in any show. You are looking for 1

    Times in any show = countx(FILTER(data,data[contactid]=EARLIER(data[contactid]) && data[StartDate]<=EARLIER(data[StartDate])),data[contactid])

    In a show how many time

    timeS in that show = countx(FILTER(data,data[contactid]=EARLIER(data[contactid]) && data[EventName]=EARLIER(data[EventName]) && data[StartDate]<=EARLIER(data[StartDate])),data[contactid])