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
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
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!