Forum Discussion

nholmes12's avatar
nholmes12
Frequent Visitor
4 years ago
Solved

Unpivot Data/ merge table

Hi All,    Still quite new to Power BI myself so looking for assistance with the below. I have the below data set in the following (excel) format which shows change in headcount and cost over time:...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi again nholmes12 ,

    I was maybe not enough clear in my previous post.
    To pivot your data : simply select your column "Value Type" and click on Pivot column. In the windows which pop-up select Value as Values column and in Advanced Options select "Don't Aggregate". It should work.


    Please accept it as a solution if it solved your issue.
    Best regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi again nholmes12 ,

I was maybe not enough clear in my previous post.
To pivot your data : simply select your column "Value Type" and click on Pivot column. In the windows which pop-up select Value as Values column and in Advanced Options select "Don't Aggregate". It should work.


Please accept it as a solution if it solved your issue.
Best regards

nholmes12's avatar
nholmes12
Frequent Visitor
4 years ago

Thanks very much!