Create a Summary Table with Summarised Columns from Other Tables

I want to create a table that summarises columns from another table but with the abiity to add extra column to that table to calculate totals from other tables

I have my main 'raw data' table in PowerBI which looks something like below. The actual full table will contain about 17500 different ID's and the Date will cover all dates from 01/09/2022 to 'today' and the Attendance Session is split in to Mornings and Afternoons and the Attendance Meaning column states whether they were Present, had an Authorised Absence or an Unauthorised Absence.

What I want to do is create a Table that summarises this data, so it looks something like this

I can create this as a table visualisation easily, but this is not what I want, I want a seperate data table to summarise the data.

Any help you can provide to create this summarised table would be very gratefully recieved