Forum Discussion

GINMED's avatar
GINMED
Icon for Helper III rankHelper III
4 years ago
Solved

Different FIRST and LAST payments

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's avatar
    vojtechsima
    4 years ago

    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

     

3 Replies

  • vojtechsima's avatar
    vojtechsima
    Icon for Super User rankSuper User
    4 years ago

    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?

     
      • vojtechsima's avatar
        vojtechsima
        Icon for Super User rankSuper User
        4 years ago

        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