A circular reference occurs here, but Excel does not generate an error.

[HJK]

Hi

Let me briefly explain the logic.

Let me briefly explain the logic. The sender's expense is sent to the receiver according to the divide factor.

The receiver becomes the sender again and sends the amount to another receiver.

A circular reference occurs here, but Excel does not generate an error.

A circular reference error occurs when Dax  is used in power bi.

1. Logic

2. Exel formula

[amitchandak]

@HJK , In power bi you do not have row-wise processing like excel. You have think cumulative to get such meausre. earlier can help

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

If this does not help
Can you share sample data and sample output in table format and logic?

[HJK]

Hi

This is excel file link

Sample.xlsx