Duplicating a Column

[jellis1971]

From the Chart of Accounts table shown in the screenbshot of Power BI below, there is the Account Category field.

I'd like to duplicate this column (field).

Using the duplicate (and the original) column, I can filter.

For the duplicate, I would filter to only show the "Cost of Goods Sold" account category. 

For the original, I would filter to only show the "Income" account category.

Then, I would be able to display amounts for each of the two categories in separate columns.

Ultimately, I'd like to have a report that looks like the second screenshot below.

So, is such a duplication of a column possible?

Thanks!

John

[jellis1971]

Yes, sir.

[v-zhangti]

Hi, @jellis1971 

Can you provide source data based on this output? Is it similar to an attachment?

Best Regards,

Community Support Team _Charlotte

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

[v-zhangti]

Hi, @jellis1971 

Is this the result you expect?

If not, please provide more information.

Best Regards,

Community Support Team _Charlotte

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