Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
there is some costs what I should put into loan schedule project - theses are fixed costs, for instance, 37,5/every month, but FIRST payment should be 31,25, and LAST one 6,25. it looks like that..How can create such measure/project??
Thank you in advance!
GINMED
Solved! Go to Solution.
Hello, @GINMED
PaymentFixed =
var FirstPayment = MINX(ALLSELECTED('Table'), ('Table'[Sequence]))
var LastPayment = MAXX(ALLSELECTED('Table'), ('Table'[Sequence]))
var CurrentSequence = SELECTEDVALUE('Table'[Sequence])
var CurrentPayment = SELECTEDVALUE('Table'[Payment])
var result =
SWITCH(
CurrentSequence,
FirstPayment, 31.25,
LastPayment, 6.25,
CurrentPayment
)
return result
Hi, @GINMED
what exactly do you want to achieve?
Change the source in PowerQuery so the first row and last rows has the fixed values you mentioned?
Hello, @GINMED
PaymentFixed =
var FirstPayment = MINX(ALLSELECTED('Table'), ('Table'[Sequence]))
var LastPayment = MAXX(ALLSELECTED('Table'), ('Table'[Sequence]))
var CurrentSequence = SELECTEDVALUE('Table'[Sequence])
var CurrentPayment = SELECTEDVALUE('Table'[Payment])
var result =
SWITCH(
CurrentSequence,
FirstPayment, 31.25,
LastPayment, 6.25,
CurrentPayment
)
return result
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |