Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unpivot Function

    Hi All,   I am connecting  a sharepoint list to Power Bi.  Also could export the data into excel to attempt the same,   Here is an example of what I'm trying to accomplish.  The colored col...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Anonymous 

     

    1) Check columns "Site", "Manager" and "Date" -> Unpivot other columns

    2) Check column "Attribute" and split column with " " as delimiter

    3) Pivot back on the first column of the splitted columns with "Value" in the values area.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I feel like this is something that ImkeF  can help with.