Forum Discussion

milkmoneymike's avatar
milkmoneymike
Helper 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 ...
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])
amitchandak's avatar
amitchandak
Super 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])
milkmoneymike's avatar
milkmoneymike
Helper I
6 years ago

Thank you this worked!