Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Thank You
MM
Solved! Go to Solution.
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])
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])
Thank you this worked!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
78 | |
68 | |
61 |
User | Count |
---|---|
144 | |
106 | |
106 | |
82 | |
70 |