Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need Help! I wish to compute for Principal and Interest. My computation is relatively simple, Interest will be computed only if total collection EXCEEDS the loan amount.
My sample data are:
For the month of March
cummulative collection of 6,920 is LESS than Cummulative loan amount, so the collection of 5,770 is purely PRINCIPAL
For the following month (April)
cummulative collection exceeds the cummulative loan amount, thus the current month collection of 5,080 should be divided into
2,000 Interest
3,080 Principal
How should i formulate my PRINCIPAL and INTEREST measure to achieve my desired output??
Any help will do. Thank you
Solved! Go to Solution.
@jmcph ,New measure assuming other are measure
Principal= if( [cummulative collection] > [cummulative loan amount], [collection] - ([cummulative collection] - [cummulative loan amount]) , blank())
Interest = if( [cummulative collection] > [cummulative loan amount], ([cummulative collection] - [cummulative loan amount]) , blank())
for else part I have used blank, but you can use other formula
@jmcph ,New measure assuming other are measure
Principal= if( [cummulative collection] > [cummulative loan amount], [collection] - ([cummulative collection] - [cummulative loan amount]) , blank())
Interest = if( [cummulative collection] > [cummulative loan amount], ([cummulative collection] - [cummulative loan amount]) , blank())
for else part I have used blank, but you can use other formula
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
98 | |
80 | |
76 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |