I want to make a visualization from some data. I want to set of the actual + forecasted (man)hours versus the available budget.
Both the actual manhours & forecasted manhours are in seperate tables. I want to make the summary per civil structure (i work in construction). So actually I think I have to make a new table (or column) wich summarizes the total hours (both actual + forecasted) in a this new table (or colum). I can do this very easily in excel but I don't seem to get the solution in Power BI.
Probably very easy but I am new to powerBI so still learning every day. For the sake of the solution I have included a simplified version of the 2 tables in which I have the data.
The simplest solution is to follow @FrankAT suggestion of creating a dimension table with unique values for the "civil Structure" field and join this diemnsion with each of your tables in a one-to-many relationship joining the respective "civil structure" fields. the create your final table visual using the "civil structure" field from the dimension table and the SUM measures as suggested. (BTW, you should also create a "week" table as a dimension to use in your final visual if you need comparisons by week)
Did I answer your question? Mark my post as a solution! In doing so, you are also helping me. Thank you!