I followed Sams Financial reporting course and it was a great intro to Power BI.
Now I want to attack a real world example in anger. Its for a firm of accountants.
Sams course used a Report Template and descriptions to trigger totals.
I have 2 problems and I am not sure how to approach it.
- There is a chart of accounts, but some accounts will have sub accounts. e.g.
225/1 Short Term Short Term Leases
225/2 No Description
225/45 No Description, i.e. Blank / Null
226 Hire of Plant & Machinery
- Chart of Account Descriptions can be overridden on a client basis.
So when their accounts are printed the priority for description is:
Client Specific if it exists
Extended if It exists e.g. Short Term Leases
Description e.g. Short Term
It doesn’t appear that I can rely on account description for summarising as I can’t be certain of the description that will come through.
I could try defining ranges, but its not clear to me how I handle the sub accounts.
Any suggestions gratefully received.
PS Give up is acceptable.