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 nholmes12 

If you have a column ValueType containing the information if it is a data FTE or Cost, it should answer your need. Am I right ? (For that simply create that column before your unpivoted column step). You will be able to work on one of the value type using filter.

 


If you absolutely want to have the value in two separated column, you just to pivot the columns Value Type and Value.

Please accept it as a solution if it solved your issue