Different FIRST and LAST payments

[GINMED]

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

[vojtechsima]

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?

[GINMED]

@vojtechsima 

I want to get some measure for my example

[vojtechsima · Accepted 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