3,482
Hi:
I know how to create a Power BI report that pulls amounts for dimensions based on the account categories of Revenue and Cost of Goods Sold.
But, I cannot get the report to mirror what is shown in the screenshot below.
The tables that I'm using are GL Entries, Dimension Set Entries, and Chart of Accounts.
It seems that there is not an obvious way to have two separate columns for Revenue and COGS.
Has anyone out there found a way?
Thanks!
John
Thanks, Inge!
Actually, inventory is not in the data. :)
John
If I was to create a report like that I would use the Item Ledger Entries table. That holds both the revenue and the COGS.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
