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

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
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi Anonymous,

     

    You may refer to my solution here.

     

    Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    This is exactly what I needed, thank you!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.