Forum Discussion

SteveMForm's avatar
SteveMForm
Helper III
2 years ago
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 ...
  • SteveMForm's avatar
    SteveMForm
    2 years ago

    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?

    ie

    1. The mystery 'of' and corresponding null value 
    2. Removing rows (and on an ongoing basis) where there are not resources for a given work item

     

    Many thanks

lbendlin's avatar
lbendlin
Super User
2 years ago

Please note that you can do the text replace across multiple columns. No need to do it one by one.

SteveMForm's avatar
SteveMForm
Helper III
2 years ago

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?

ie

1. The mystery 'of' and corresponding null value 
2. Removing rows (and on an ongoing basis) where there are not resources for a given work item

 

Many thanks

  • SteveMForm's avatar
    SteveMForm
    Helper III
    2 years ago

    closing this as no reply