Forum Discussion

Hoping's avatar
Hoping
Helper III
2 years ago

Access a Column from Dynamic Value in Text Box

I want to access Column 2 of a table based on Column 1 in the same table in Dynamic Value Updates of a Text box.

 

I want to get Column 2 value where Column 1 value = "A"

 

What prompt should I use in the Dynamic Value Update to get the contents of Column 2 corresponsing to value "A" in Column 1.

 

Column 2 is basically a text which I want to display for specific values in Column A.

Need Help

2 Replies

  • wini_R's avatar
    wini_R
    Solution Supplier
    2 years ago

    Hi Hoping,

     

    not sure if I get it right as the question is too vague but you might try this formula:
    CALCULATE(SELECTEDVALUE(tableName[Column2]), [Column1] = "A")

     

    If that is not what you need, please provde more details or an example.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?