Reference a formula from previous row

@Roboboboberts The result you are looking for is not achievable with DAX. However, it might be obtained with PQ and our M code expert @Melissa can say mo re about this.

Thanks.