Absence in a Rolling 10 Week Window

From September 2024, schools will need to be able to track the number of sessions (half days) of unauthorized absence in a rolling period of 10 school weeks. This period of 10 weeks can span holidays and academic years. The Department for Education is coming at this from the perspective of a threshold measure for […]

Education Data Modelling

A look at modelling data for Power BI in an education setting.

Week on Week Comparisons

Working for a multi academy trust I was asked to provide comparison of a range of measures (attendance and suspensions) by week with the same week the previous year. On the face of it this sounds simple until you realise that each academy has slightly different term dates and within that use inset days differently […]

Calculation Groups and RLS

I had a specific requirement to be able to show summary data for a whole organisation ignoring any RLS while being able to slice by all attributes. At the same time I needed to only show data attributed to names, for particular groups defined by RLS. There are many approaches to doing this. One I’d […]

Data Model Vs DAX

In this post we look at how leveraging the data model correctly can simplify our DAX and increases report speed. Using a dataset with 10,000,000 rows we will use Power Query to make a change that reduces the render time for a visual from 15.6 seconds to 1.6 seconds. A classic requirement is one of […]

SUMMARIZECOLUMNS and Filters

This blog post originated from a question in the Power BI Community forum. The final solution is very straight forward but my aim is to illustrate an underlying behaviour in Power BI with a simple example. The problem can be seen in this pbix file. We have a basic data model: With the following two […]