Creating new columns based on 2 other columns

[Anonymous]

I have a dataset which contains information about the cost of different products. It is based on 6 months worth of data. Each month (July-Dec) was one file, which I combined into one table on Power BI. 

There is one 'Cost' column which I need to split into 6 different columns, one column for each month.

i.e. July Cost, August Cost, Sept Cost. 

I am trying to figure out how I can split the Cost column based on each Source.Name. 

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Please try to get the data using the default folder connector and select the merge data option in the navigation.
You will get the combined data in the Power Query with an additional column for the source name, and then you can use the UI to change the contents of the column to get what you want.

Result:

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , One way is append, if you have month name in them and then unpivot

Another way append with value column name named as different month

Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.