Forum Discussion
Crosstab in a New Measure
Hi, very new to Power BI, but enjoying it so far.
I have an education dataset and want to track the occurances of students being late to class. Fields are:
Day (Monday to Fri)
Session (Text - morning, afternoon, evening)
Absense Type (Text - Late, Absent, etc)
Absent Mins (Integer)
Date
I want to create a crosstab in Power BI, that counts records with the number of absent mins > 0 in a crosstab of Day and Session where Absent Type = "Late". I woud like to use a slicer on Date.
Can this be done in a New Measure? If not, how?
Thank you,
Q
1 Reply
Hi pickslides
I think this should be possible. But can you provide some sample data which is copyable and show what the crosstable should be like based on the sample data? This would help us understand the expected result better and provide a possible solution quickly. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Best Regards,
Community Support Team _ Jing
