Forum Discussion

John117's avatar
John117
New Member
4 years ago
Solved

Create table with what-if parameters

Hello!   I'm trying to create a dynamic table with DAX functions where one of the columns shows the value that user input in the what-if parameter. For example if the user enter these values for wh...
  • Nathaniel_C's avatar
    Nathaniel_C
    4 years ago

    Hi John117 

    Try this:

    • Create a table with one column with the Value names
    • Create the measure below

    I used an IF() but use a SWITCH () if there are more values.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

    Value table =
VAR _curValue1 = 'Value 1'[Value 1 Value]
VAR _curTableValue =
    MAX ( newtable[Value] )
VAR _curValue2 = 'Value 2'[Value 2 Value]
RETURN
    IF ( _curTableValue = "Value 1", _curValue1, _curValue2 )

     

johnChu's avatar
johnChu
New Member
3 years ago

Hi Nathaniel_C,

I found this is interesting for learning what if parameter. But if there are three or more what if parameters, how could we retrieve the current value, that is, how to modify _curTableValue statement? If we still use MAX, it always returns the biggest  value (value 3 if 3 what if parameter).

thanks