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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks the solutions from lbendlin and Greg_Deckler 

    Hi，SteveMForm 

    Have you tried Greg_Deckler suggestions? In the existing query, create a new blank query that will link to your SharePoint file. Then replace the source of the existing query with the M code of the query, which is aimed at the following problem:
    How (and what) do I replace the source in the query in this post with my source?

     

     

    Best Regards

    Jianpeng Li

     

     

     

     

     

     

     

    • SteveMForm's avatar
      SteveMForm
      Helper III
      2 years ago

      Hi Anonymous - I'm working through it query by query- there are some possible issues but this could be with the orignial Power Query, rather than it's implementation.

       

      One of the first things I have gone back to doing is replacing blanks and null values in the Work Tracker data table, to try and avoid having to split the table if possible, and as some of the query steps produced erros (eg Capitalising a null value as it isnt text).

      I have a spearate Post here related to it: How can I Replace null values in Person-based colu... - Microsoft Fabric Community as it seems difficult to replace values in a SharePoint based Person column which I have transfored to extract records in but can't replace the null values.

       

      WIll post tomorrow

      • SteveMForm's avatar
        SteveMForm
        Helper III
        2 years ago

        Anonymous solved the nulls and blanks- will move on tomorrow to applying the queries also as some column names have changed due to expanding the name columns as they were records so the query needs updating