Hi @Fram ,
Sorry for my wrong understanding.
If your Loss is calculated in terms of Total, but your Total is also calculated in terms of Loss, it seems impossible to implement in Power Query.
This is because in Excel, each cell of yours can be treated as an independent operation, not in Power Query.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.