Modeling help

[swebb]

All,

I'm trying to create a finane report from business central data, but I'm struggling with modeling. I have 4 environments/tables that all have the same expenses. Should I just write a measure to get a sum? I have multiple tables imported in to Power BI representing the different locations, but the end user is wanting a summarization of all expenses across all regions/companies. 

[amitchandak]

@swebb , If they have the same structure, I would suggest appending them in the power query

Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

For any complex display you can check, if needed

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU