Multi use What-If

[iantemte]

We are a financial institution.

Looking to do an interest rate study per loan type.

We want to use what-if parameter slicers to study loan rate changes on recent bookings like this:

how might i have separate what-if parameters per loan type adjust each loan type respectively?

I was thinking loan-type VAR cast in a measure, but cannot get it to work!

Thanks for your help,

Ian

[v-yanjiang-msft · Accepted solution]

Hi @iantemte ,

According to your description, I think you want to create two parameters, one for the local loan rate changes and another for abroad loan rate changes, if this is the case, here's my solution.

Create two what-if parameters.

Create two measures.

Rate Hypothetical delta =
SWITCH (
    MAX ( 'Table'[Loan Type] ),
    "Local Loans", 'Local'[Parameter Value],
    "Abroad loans", 'Abroad'[Parameter Value 2]
)

New Rate = MAX('Table'[Recent booking rate])+'Table'[Rate Hypothetical delta]

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[parry2k]

@iantemte did you test what I proposed? From your reply, it is not clear if you test what I provided?

[parry2k]

@iantemte you can easily do this, let's say you have two what-if parameters, loan type 1 and loan type 2

and this is what you will do in your measure:

Loan Rate Change =
VAR __loanType = SELECTEDVALUE ( Table[LoanType] )
RETURN
SWITCH ( __loanType, 
   "Local Loans", [Loan Type 1 Value],
   "Abroad Loans", [Loan Type 2 Value],
   0 --else value
)

New Rate = 
MAX ( Table[Recent Booking Rate] ) + [Loan Rate Change]

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[iantemte]

Please let me clarify:

i have recently booked an amount @ a given rate in 2 loan types.

i want to theorize profitability if my given rate was at an adjusted rate per loan type.

i want rates to be adjusted with what-ifs generated by GENERATESERIES

the rate displayed by the GENERATESERIES is picked by a slider using a SELECTEDVALUE measure.

how do i allow myself to pick different alternate rates per loan type with corresponding sliders?

ie:  slider 1 affects LOCAL LOANS and slider 2 affects ABROAD LOANS.

NEW RATE is simplY SELECTEDVALUE + RECENT BOOKING RATE