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

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Please advise where I can upload the file then?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Try Google Drive.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I can't access Google drive on my PC and cannot work out how to share a file with just anyone in One Drive. 

         

        I'm also totally stuck on how to dummy the data in my existing file, so all I've done is copied the sample data from my Excel workbook into a blank Power BI file. In which case I've pasted the tables from the workbook below, you should be able to copy these into a blank PBI file, right? I've specified the data types in brackets for each column. I'm happy to then work out how to implement the solution into my real file. 

         

        Apologies I can't achieve what you're asking and would appreciate any help that can be provided.

         

        ProjectId (text)Project Name (text)
        1a2345cd-6e7f-g8901-12h3-45678i901234Project A
        1a2345cd-6e7f-g8901-12h3-45678i901238Project B
        1a2345cd-6e7f-g8901-12h3-45678i901236Project C
        1a2345cd-6e7f-g8901-12h3-45678i901237Project D
        1a2345cd-6e7f-g8901-12h3-45678i901235Project E

         

        ProjectId (text)Project Name (text)Title (text)Rating (Whole Number)
        1a2345cd-6e7f-g8901-12h3-45678i901234Project ARisk 43
        1a2345cd-6e7f-g8901-12h3-45678i901236Project CRisk 33
        1a2345cd-6e7f-g8901-12h3-45678i901235Project ERisk 73
        1a2345cd-6e7f-g8901-12h3-45678i901236Project CRisk 82
        1a2345cd-6e7f-g8901-12h3-45678i901237Project DRisk 52
        1a2345cd-6e7f-g8901-12h3-45678i901235Project ERisk 22
        1a2345cd-6e7f-g8901-12h3-45678i901234Project ARisk 11
        1a2345cd-6e7f-g8901-12h3-45678i901238Project BRisk 111
        1a2345cd-6e7f-g8901-12h3-45678i901237Project DRisk 91
        1a2345cd-6e7f-g8901-12h3-45678i901237Project DRisk 101
        1a2345cd-6e7f-g8901-12h3-45678i901235Project ERisk 61