Forum Discussion
Solved
Unpivoting table Power Query and DAX code
Hi Folks reaching back out to lbendlin. You sweated for me on this one a little while ago: Solved: How to show Staff Capacity against Work by Month - Microsoft Fabric Community When ...
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
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.