@sunip thank you very much - the methodology used in the post now correctly helps pull the ‘status last period’ question for me.
The last piece is around aggregating these findings … I’ve re-attached the file and need to somehow aggregate the entire “did status change” column. SUMX isn’t doing it for me because when DAX is evaluating each row of the table, it can’t reach back into a previous day (it calculates ‘status last period’ as 0 for each day it’s evaluating)
Sample Progression P WC.pbix (141.2 KB)