Forum Discussion

iantemte's avatar
iantemte
Regular Visitor
4 years ago
Solved

Multi use What-If

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:   ...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

     

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

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.