Forum Discussion
Distribute data over defined categories
Hi tokyobaer
Sorry I missed that bit about RESS02/RESS03. We can do it using two queries from table 1. The first we filter to only RESS01 and apply table 2. The second we filter out RESS01 then apply the GRP logic. Finally we combined those table together.
I updated my .pbix file https://www.dropbox.com/s/nipbf7dgs45t78r/ProjectHours.pbix?dl=0
Correction: There was a typo in Table 1...
| PRJ-ID | Ressource | Hours |
| BM-001 | RESS01 | 12 |
| BM-001 | RESS02 | 23 |
| BM-001 | RESS03 | 34 |
| BM-002 | RESS01 | 56 |
| BM-002 | RESS03 | 67 |
| BM-003 | RESS01 | 89 |
But this should not change anything about the previous discussion regarding the "partial unpivot".
Super UserHi tokyobaer
Sorry I missed that bit about RESS02/RESS03. We can do it using two queries from table 1. The first we filter to only RESS01 and apply table 2. The second we filter out RESS01 then apply the GRP logic. Finally we combined those table together.
I updated my .pbix file https://www.dropbox.com/s/nipbf7dgs45t78r/ProjectHours.pbix?dl=0
That's cool - it works exactly as I intended. With a bit of additional studying I learned a lot about Power Query and the M language over the weekend, and I am impressed... Thank you!