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

Fair points, but please keep in mind that this forum is where users help each other, time permitting, and to the best of their abilities. You changed the scope and complexity of your request quite a bit, to the point where it exceeded my abilities (as an example). Maybe start over with a simpler ask. 

 

If you need this covered professionally you can engage with one of the Microsoft partners in your area.

SteveMForm's avatar
SteveMForm
Helper III
2 years ago

Hi lbendlin thanks for your response and appreciate the reflection.

 

I think the scope was always the same, ie the problem I was trying to solve, it just got more involved as it unpacked.

 

The last query I had on what bit of the power query do I need to replace/ need still seems kinda basic.

 

Appreciate others help time permitting, but when they don't respond but are online, I personnaly just need a - 'I don't know, it's beyond me' response. Obviously the limit of ability is a fair shout, and good to let people know.

 

I might well look to engage a Microsoft partner and prob can through work although it will be protracted- I cant afford this personnaly if it costs.

 

A simple ask now would be- what do I replace in this and the previous posts Power Query with my own source ID, and do I have the right data as my source ID (see message 15 here)

At least I can do the pivots and split the tables then 🙂