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.
Hola, chicos
Estoy tratando de hacer un capital acumulativo continuo por préstamo de la siguiente manera:
schdule | Préstamo | Principal | Fecha de vencimiento | ¡RT REQUERIDO! |
1 | 1abc | 300 | 1/1/2022 | 300 |
2 | 1abc | 300 | 2/1/2022 | 600 |
3 | 1abc | 300 | 3/1/2022 | 900 |
4 | 1abc | 300 | 4/1/2022 | 1200 |
5 | 1abc | 300 | 5/1/2022 | 1500 |
6 | 2df | 200 | 1/1/2022 | 200 |
7 | 2df | 200 | 2/1/2022 | 400 |
8 | 2df | 200 | 3/1/2022 | 600 |
9 | 2df | 200 | 4/1/2022 | 800 |
10 | 3gh | 500 | 1/1/2022 | 500 |
11 | 3gh | 500 | 2/1/2022 | 1000 |
12 | 3gh | 500 | 3/1/2022 | 1500 |
13 | 3gh | 500 | 4/1/2022 | 2000 |
14 | 3gh | 500 | 5/1/2022 | 2500 |
He estado revisando el foro y he probado varias respuestas, pero nada funciona.
Intenté con lo siguiente pero me da el total completo no acumulado por fecha.
Column = CALCULATE( SUMX(loanschedules, loanschedules[principal]), filter(ALLEXCEPT(loanschedules,loanschedules[_loan]), loanschedules[Date.1] <= max(loanschedules[Date.1])))
Gracias a todos de antemano.
Bien
Solved! Go to Solution.
Resuelto. gracias a todos
Column = CALCULATE(SUM(loanschedules[principal]), FILTER(ALLEXCEPT(loanschedules,loanschedules[_loan]), loanschedules[Date.1] <= EARLIER(loanschedules[Date.1])))
Resuelto. gracias a todos
Column = CALCULATE(SUM(loanschedules[principal]), FILTER(ALLEXCEPT(loanschedules,loanschedules[_loan]), loanschedules[Date.1] <= EARLIER(loanschedules[Date.1])))
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 |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |