Reply
jellis1971
Helper IV
Helper IV
Partially syndicated - Outbound

Duplicating a Column

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

 

 

Capture.PNG

 

jellis1971_0-1679084953465.png

 

3 REPLIES 3
jellis1971
Helper IV
Helper IV

Syndicated - Outbound

Yes, sir.

Syndicated - Outbound

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
Community Support
Community Support

Hi, @jellis1971 

 

Is this the result you expect?

vzhangti_0-1679381621921.png

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)