Forecasting / Financial Reporting questions on layout method using DAX

DAX
1

Hi everyone,

I working on creating a financial report. I have seen a couple different methods on creating an income statement.

One method is have Income Statement Template, create DAX formulas for values, totals and subtotals to included in the Income Statement Template and use Switch-True method with this DAX totals and subtotals and values forumulaes based on Financial Reporting in Power BI course (plus I have seen this method if a few other courses / videos).

Another method that I have seen creating an Income Statement is creating the DAX formulas for each row in the report and in the format section under Values-Options turn on the Switch values to rows. I realize this method gives the totals and subtotals but their listed as Totals. I saw this method in Udemy course on Financial Reporting and also a Financial Modelling course for Power BI.

So now for my question(s).

  1. With the second method of turning on the Switch values to rows, does this have any impact on the DAX formulas work?
  2. Has anyone seen this second method before? If yes, what are the benefits of doing this method over the first method?

Any other comments on this would be interesting to know in general.

The reason I would like to understand these 2 methods better because I want to creating some basic forecast revenue models where revenue = hours worked x number of employees x selling price and cost = hours worked x number of employees x average salary. Then calculate the profit = revenue - costs. A simple model initially then add in some what if scenarios to some of the inputs.

Thanks for all who respond.

David

1 Like
3

Hi @DavidHalliday - I haven’t seen the second method but the first method by SAM seems the best way to create a Income statement/Financial reporting.

If you can provide some reference or link for second method, then I can check and provide my inputs.

Thanks
Ankit J

4

Hello @DavidHalliday

We notice that no response was received from you on the post above.

We are waiting for you the second method you’ve mentioned so other users can help you in your query.

Due to your inactivity, we’ll be tagging this post as Solved.

Should you wish to add the required detail/information/file you can reopen this thread.

Thank you!