Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
swebb
Helper II
Helper II

Modeling help

‎02-15-2023 01:14 PM

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. 

Labels:
Message 1 of 2
233 Views
0
1 REPLY 1
amitchandak
Super User
Super User

‎02-15-2023 06:50 PM

@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



Message 2 of 2
183 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All