Financial Report Templates

Hi
You helped me previously with calculating accumulated balance sheet figures which was very helpful.

In the same accounting system users have the ability to generate their own templates for Revenues and Balance Sheet reporting. I want to create reports by interpreting the templates.

I have gone through your on line videos on financial reporting using templates but the methodology is a little different so I am really struggling with the DAX.

I have attached the pbix file so you can see how it is intended to work.

If you look at either of the Template tables you will see how we envisage it.

  1. The template should be processed in Sequence order

  2. There are three line types:
    a) Header - Just simple text.
    b) Data - the data is to be calculated as the sum of table NlTransactionsPosted Amount
    column. The NominalCode is the relationship in both tables.
    c) Calculated - data is calculated from related Sequence Line and it allows use of a number of operation codes:
    add
    adr (same as add but add a range of lines.
    sub
    mul
    div
    %
    cpy (simply copy from another location)

If you could assist with examples of how the DAX should be constructed for each line type I should be very grateful.

PaulAccounts.pbix (1.3 MB)

Hi @PaulBoyes, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.
  • When posting a topic with formula make sure that it is correctly formatted to preformated text </>.
  • Use the proper category that best describes your topic
  • Provide as much context to a question as possible.
  • Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.

Hi Paul,

I believe the Financial Reporting covers in quite a lot of detail exactly what you are looking for.

From what I can tell you aren’t using templates in your tables…

If you want to get a certain order and custom table then you really need to use the template approach covered in the course module.

Here’s a few videos to review.

This is an example of the type of formula you need

But it depend on your exact requirements.

From what I can currently see this technique isn’t being used and enables the full customization that you are likely after.

This entire course above is what you want to focus on for this type of analysis in Power BI.

Thanks
Sam

Hi @PaulBoyes, we’ve noticed that no response has been received from you since the 30th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!