Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |