Financial Reporting B/S Values dax formula

DAX
1

Hi,
General Ledger Report Category List.xlsx (26.3 KB)
Screen shots.xlsx (102.2 KB)

I can’t seem to get the totals to show using the template approach for financial reporting financial reporting. We have a different layout of tables than the demo.
I’ve attached some screen shots of the formulas and the template I am using.
Can you help? Let me know if you need more info.
Thanks
Melissa

2

Bumping this post for more visibility from our experts and users.

3

Hi @Meldon - Can you share the PBIX file for this.

Thanks
Ankit J

4

Sorry I can’t.

5

Hi @meldon

Did you review the course for financial reporting in power bi within the education portal? It might help you with the totals

thanks
Keith

6

Yes, it’s where the idea came from. The structure of their data is different. I’ve been trying for ages to get it to work.

7

@meldon - Ok in that case is it possible to share some sample data for other tables and “Manage Relationship” info. In that case I may try to help.

Thanks
Ankit J

1 Like
8

image

From Manage Relationships

9

I hope these sample files help. This is just one line for current assets, so you can see if anyone to get the ‘Total Current Assets’ line to bring in the total.
Account Balances.csv (330 Bytes)
GL Accounts Header.csv (209 Bytes)

10

I’ve added some sample files. Let me know if you need something and I can try and get it.

Thanks

11

ok im getting closer, I had to remove the join between the BS report Structure. Now I have to fix the other subtotals.
image

12

I think I can solve it myself now.

1 Like