One set of group numbers, from four ledgers
Four legal entities in D365 Finance, each with its own chart of accounts, consolidated in a spreadsheet every month. We built a single Power BI semantic model with a mapped reporting chart of accounts, intercompany elimination, and drill-through from group figure to source transaction.
