I know its been asked and I have checked all the suggested articles, but I need some help! I'm trying to get this:This image is from thebiaccountant. The guy talks way over my head and every time I feel like I have a solution, it doesn't work or the DAX formula doesn't do what I want it to. I'm trying to sort the GLAcountName into the appropriate Sales, Cost of Sales, and Expense categories but I am struggling here. Any tips or suggestions would be great. I've tried new columns, and tables but really don't know how to get the data correct. I've uploaded the pbix below so you can see what I am working with. Well I can't even seem to find where to upload that!

The most important thing to make a P&L work is having a good chart of accounts as a lookup table. I learnt everything I know from this video. https://www.youtube.com/watch?v=ojHZkWkEY7Q/

It's in your first post - I'm "The guy" ;-)(Unfortunately Microsoft decided to delete the signatures here in the forum and I gave up adding them manually)

O dear... I was about 80 pct finished in building a p and l, however I think these links you two provide may bring me back to the drawing board.

Hi kenthub,you cannot upload files directly on the forum here. Instead, load them to a web storage (like dropbox ie) and paste the link here. The link MattAllington has pasted is a completely different concept compared to mine and will not help you for my model. You have to choose between the 2.

Here is the PBIX File We do utilize a good Chart of Accounts. Take a look and let me know what you think.... If we need to make the changes from the report we pull from NAV then that might have to be the option. Thanks all!

Profit and Loss statement - help with hierarchy

17 Replies

MattAllington
Community Champion
8 years ago
The most important thing to make a P&L work is having a good chart of accounts as a lookup table. I learnt everything I know from this video. https://www.youtube.com/watch?v=ojHZkWkEY7Q/
- Anonymous
  Not applicable
  8 years ago
  O dear... I was about 80 pct finished in building a p and l, however I think these links you two provide may bring me back to the drawing board.
ImkeF
Community Champion
8 years ago
Hi kenthub,
you cannot upload files directly on the forum here. Instead, load them to a web storage (like dropbox ie) and paste the link here.

The link MattAllington has pasted is a completely different concept compared to mine and will not help you for my model. You have to choose between the 2.
kenthub
Helper I
8 years ago
Here is the PBIX File

We do utilize a good Chart of Accounts. Take a look and let me know what you think....

If we need to make the changes from the report we pull from NAV then that might have to be the option.

Thanks all!
- ImkeF
  Community Champion
  8 years ago
  To help you set up my model, you would have to provide that Chart of accounts table as well.
  
  Or to be more precise: We need a table which contains the definition of which accounts go into which (sub-) totals (or account groups).
  - kenthub
    Helper I
    8 years ago
    Gotcha. How or what would you use to connect the two tables? Like the YouTube video above shows there are headings, subheads, sub-subheadings, etc. Would it be best to associate a number linking the specific Chart of Account (Revenue, Cost of Sales, etc.) to the desired GL number? Or would you used some other method of connecting the tables?

Forum Discussion

Profit and Loss statement - help with hierarchy

17 Replies

Related content

Date hierarchy

Non-Profit Licensing Options

Calculate Gross margin in Profit and Loss statement

OR Statement ?

Bringing net profit from profit and loss statement into Balance Sheet