Forum Discussion

gduobaite's avatar
gduobaite
Helper III
5 years ago
Solved

Retrieve values from another table

Hi all,    I have two tables (Table & Table(2)) related through "z_score_rnd" column. I need to show "100" (number) value in "score %" colum for the scores, which are >=4 or <=-4 from Table(2). I...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi gduobaite ,

    You can create this column:

     

    Column =
IF (
     ( [z_score_rnd] >= 4
        || [z_score_rnd] <= -4 )
        && [z_score_rnd] IN DISTINCT ( 'Table (2)'[z_score_rnd] ),
    100,
    [score %]
)

     

    Attached the file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gduobaite's avatar
gduobaite
Helper III
5 years ago

I tried:

Column  = IF('Table2'[z_score_rnd]>=4 || 'Table2'[z_score_rnd]<=-4, 100)

If I would only know how to implement false value (false should be all remained % values from Table1, "score %")...

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi gduobaite ,

    You can create this column:

     

    Column =
IF (
     ( [z_score_rnd] >= 4
        || [z_score_rnd] <= -4 )
        && [z_score_rnd] IN DISTINCT ( 'Table (2)'[z_score_rnd] ),
    100,
    [score %]
)

     

    Attached the file in the below, hopes to help you.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.