March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
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).
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
84 | |
82 | |
74 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |