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

I would recommend you use separate tables.  One for the projects and the other for the assigned resources.

SteveMForm's avatar
SteveMForm
Helper III
2 years ago

I was just thinking it may be a limiting factor if I understand how you are approaching unpivoting.

 

So, to confirm, what data are are you suggesting is in each table, and is the creation of the separate tables in Power BI, not at source?

 

At the moment, all items are held in one SharePoint list in the data source, and preference would be to keep it that way.

 

Is it possible to split the data in Power BI, creating the two tables?