Forum Discussion
Solved
Sum Column in one table from column in another table based on other columns
I am putting together an analysis of supply and demand for resource planning, and am having a difficult time getting the view I would like. Table A contains resource, year, month, and hours. Tab...
Hi ebuchholz,
Please check out the demo in the attachment.
Seems you just need to establish a relationship using [Resource] and create a measure.
Measure = sum(Table1[Resource Supply]) - sum(Table2[Hours Demand])
Best Regards,
Dale
Hi ebuchholz
Can you post some sample data with expected output ( in copy & pasteable format)?
Thanks
Raj