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.

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.

    • 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Please advise where I can upload the file then?