Forum Discussion
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...
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-45678i901234 | Project A |
| 1a2345cd-6e7f-g8901-12h3-45678i901238 | Project B |
| 1a2345cd-6e7f-g8901-12h3-45678i901236 | Project C |
| 1a2345cd-6e7f-g8901-12h3-45678i901237 | Project D |
| 1a2345cd-6e7f-g8901-12h3-45678i901235 | Project E |
| ProjectId (text) | Project Name (text) | Title (text) | Rating (Whole Number) |
| 1a2345cd-6e7f-g8901-12h3-45678i901234 | Project A | Risk 4 | 3 |
| 1a2345cd-6e7f-g8901-12h3-45678i901236 | Project C | Risk 3 | 3 |
| 1a2345cd-6e7f-g8901-12h3-45678i901235 | Project E | Risk 7 | 3 |
| 1a2345cd-6e7f-g8901-12h3-45678i901236 | Project C | Risk 8 | 2 |
| 1a2345cd-6e7f-g8901-12h3-45678i901237 | Project D | Risk 5 | 2 |
| 1a2345cd-6e7f-g8901-12h3-45678i901235 | Project E | Risk 2 | 2 |
| 1a2345cd-6e7f-g8901-12h3-45678i901234 | Project A | Risk 1 | 1 |
| 1a2345cd-6e7f-g8901-12h3-45678i901238 | Project B | Risk 11 | 1 |
| 1a2345cd-6e7f-g8901-12h3-45678i901237 | Project D | Risk 9 | 1 |
| 1a2345cd-6e7f-g8901-12h3-45678i901237 | Project D | Risk 10 | 1 |
| 1a2345cd-6e7f-g8901-12h3-45678i901235 | Project E | Risk 6 | 1 |
This is exactly what I needed, thank you!
You are welcome.