Cumulative interest payments in loan amortization schedule

[GINMED]

Hi, I need your help - 

to create cumulative interest payments for loan amortization calculation.

I have calculation for INTEREST, but i need CUMULATIVE INTEREST also required.

There is my sample data.

Hoping for your support,

GINMED

[Charlie543]

Sample data link is not working 

$50 loan instant app

[GINMED]

Sample data there

[danextian]

Hi @GINMED ,

The link to your sample data no longer exists. In the interim, you may try the following:

**bleep** Interest =
CALCULATE (
    [sum of interest],
    FILTER ( ALL ( Table[Date] ), Table[Date] <= MAX ( Table[Date] ) )
)


**bleep** Interest =
CALCULATE (
    [sum of interest],
    FILTER ( ALL ( Table[Sequence] ), Table[Sequence] <= MAX ( Table[Sequence] ) )
)

The measures above will, of course, depend on your data model (separate dates table, etc).

[GINMED]

@danextian 

thank you for quick answer, but I've tested those allready - those doesn't work:((

[GINMED]

@danextian 

THERE IS MY SAMPLE DATA