Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unpivot/Pivotting Table

Hi All

 

need assistance with pivotting/unpivotting a table via powerbi desktop

i have date output in powerbi similar to this structure below

 

 

 

i have unpivoted other columns when selecting the Name column, and that gets me to an output of below, but not quite what i am wanting. ive tried other ways and i am not sure i started in the right way and need some guidance if possible

 


the output structure i am trying to achieve iswhat i am trying to do is merge or pivot/unpivot tables so that to end result starts to look this 

 

 

thanks for helping



Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      thanks amitchandak 

      when i follow the document and your scenario i get errors

      when i pivot table, i am highlighting just the new custom column (which has Date and Prod) and i pivot on that. ensuring "Dont aggregate" is set in advance options

      from there i have the right structure but the cells in both Date and Prod have an error

      ive blanked out the name but what am i missing?

      could it be that due to the Value column has multiple values that are the same? then do i need add an index of sorts?

  • anitha_santhan's avatar
    anitha_santhan
    Regular Visitor
    5 years ago

    I am not sure if this works. But , please try .

     

    First unpivot all date columns 

     

    Then on the next step unpivot all product columns 

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      thanks

       

      that works somewhat, but even in your example...what it does it duplicate values across dates.
      there should only be 1 reference of a date and product for each person (for each date)