I need to set up a new table pulling Data from 3 different tables.
The first Data i want to pull is a Service order #
The Second is a Total Cost
The Third is a Total 3rd Party Cost
Im trying to calculate the grand total that hits the SO#
the 3 files are linked by SO#
Below is sort of how I need it to look, but with a column for grand total that adds the 2 totals.
This is going to depend heavily on your model. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Datanaut!