Forum Discussion
Earliest Attendance Count
Please see sample data and Table report. What I want to create a matrix with my report.
I have students attended different sessions from different schools and regions. One student can have many sessions booked and attended but it doesn't matter as I want am after is to Unique of the earliest attendance as u can see Bronte school appeared 3 times but I want the first time bronted attended using the attendance column and date . I hope my explanation is good enough . Thanks.
Date = Filter
Status = Filter
State Column
Region,LP and Org Name all rows
12 Replies
- Greg_Deckler
Community Champion
You would use MIN or MINX to get your earliest date.
- Greg_Deckler
I don't know what that means, I do not see any counts in your sample report.
My thought is, post your data as text that can be copied. Don't make me type your data and figure out if it is one table or 5 and what the relationships are. Post your expected output from that sample data. You will then get an answer fairly quickly. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
