Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

LOOKUPVALUE Question

  Hello,   The below code looks for an ID from Table1, in Table2. If it finds a matching ID, it returns a value for the ID from Table2 that I'm using in a line graph.   What I want to do is have...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi ， Anonymous 

    I don’t know if I understand you correctly. I made a demo, I hope it will be helpful to you.

    I create  a calculated table by using two tables:

    Table1+2 = DISTINCT(UNION(SELECTCOLUMNS(Table1,"ID",Table1[_ID]),SELECTCOLUMNS(Table2,"ID",Table2[_ID])))

    Then add two  calculated column into the table:

    Table 2 - value = IF(ISBLANK(RELATED(Table2[Table2  Value])),0,RELATED(Table2[Table2  Value]))
    Table 2 - value = IF(ISBLANK(RELATED(Table2[Table2  Value])),0,RELATED(Table2[Table2  Value]))

    it shows as below:

     

    Pbix attach 

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi ， Anonymous 

I don’t know if I understand you correctly. I made a demo, I hope it will be helpful to you.

I create  a calculated table by using two tables:

Table1+2 = DISTINCT(UNION(SELECTCOLUMNS(Table1,"ID",Table1[_ID]),SELECTCOLUMNS(Table2,"ID",Table2[_ID])))

Then add two  calculated column into the table:

Table 2 - value = IF(ISBLANK(RELATED(Table2[Table2  Value])),0,RELATED(Table2[Table2  Value]))
Table 2 - value = IF(ISBLANK(RELATED(Table2[Table2  Value])),0,RELATED(Table2[Table2  Value]))

it shows as below:

 

Pbix attach 

 

Best Regards,
Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-easonf-msft  Thank you! This gets me where I want to be; bringing in the values for each project ID from table 1 in to a line and clustered column chart, and all values for each project from table 2 as a separate line, whether or not the projects from table 2 exist in table 1. There are additional fields being brought in to this visualization and some nuances that I haven't explained, but suffice it to say that this works.