Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Return the highest value from another table for each row

I have a table of projects (one row per project), then a table for risks and another for issues associated to each project (there can be any number of rows per project in these tables). I'd like to a...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi Anonymous,

     

    You may refer to my solution here.

     

    Hope this helps.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

If there is relationship between the three tables? Could you please create three fake sample table table for further analysis? So that we can post solution which is close to your requirement. Thanks for understanding.

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Angelia

 

Yes there is a relationship between the 3 tables via the ProjectId. These are the standard tables for Project Online available via the Project Reporting OData feed (I've just renamed a lot of the columns). Attached is a screenshot showing the relationship between the tables and sample of the risks/issues tables that shows the Priority value; which is a Whole Number (1-3). I was hoping to perform a type of merge that picks up the first Priority value for each Project Id; similar to how a VLOOKUP would work in Excel where it returns the first match it finds (if I sorted the Risks/Issues tables descending by Priority, it would pick up the highest one for each project). 

 

Thanks

Olivia

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi Anonymous,

     

    Share the link from where i can download your file and also show the expected result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi

       

      The file contains confidential information. Here are screenshots of sample data with a formula I would use in Excel to achieve this. Is it possible to achieve something like this in Power BI? The yellow column shows the result I'm after.

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Yes.  This should be possible.  Dummy your dataset and share the download link.