Forum Discussion
Unpivoting table Power Query and DAX code
Hi lbendlin Greg_Deckler Anonymous
sorry for delay- Ive been off work ill for 2 weeks.
Can anyone pick up on the 2 issues I encountered on the Power Query, listed in message 27?
ie1. The mystery 'of' and corresponding null value
2. Removing rows (and on an ongoing basis) where there are not resources for a given work itemMany thanks
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
thanks lbendlin - link as follows, hope it works: https://drive.google.com/file/d/1dojJ7pQ56akvamBumsHtMFlBjuUCKbv_
The link says I need to ask for access.
should be sorted now
You have work items without any resources. How should these be presented? If you want the resources to be unpivoted you have to have data in at least one of them.