Forum Discussion

Dante79's avatar
Dante79
Frequent Visitor
7 years ago
Solved

Show column count for each user

Hi, I'm very new to Power BI.   I'm trying to create a Matrix that extracts the below Excel data and outputs to the following table, so I can create a few visual graphs from the 2nd table. Would...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Dante79,

     

    I hope instead of merge, Unpivoting the column would helped you.

     

     

    Best Regards,

    Ravi

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This i have done by taking sample data you provide.

  • Dante79's avatar
    Dante79
    Frequent Visitor
    7 years ago

    Thanks for your prompt reply !

     

    I tried some of the steps in the link and managed to merge the columns into one but still can't figure out how to achieve the output table view that I desired.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Dante79,

       

      I hope instead of merge, Unpivoting the column would helped you.

       

       

      Best Regards,

      Ravi

      • Dante79's avatar
        Dante79
        Frequent Visitor
        7 years ago

        Thanks Ravi !

         

        You've been a great help ! Really appreciate the gesture to do a video call to teach me step-by-step too. Two thumbs up !