- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes, sir.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-11-2024 01:07 AM | |||
09-04-2024 10:26 PM | |||
08-28-2024 02:53 AM | |||
07-05-2024 01:32 PM | |||
08-15-2024 02:59 PM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |