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.