Forum Discussion
Solved
Sum data from different tables based on rows value
Hello everyone, What I'm trying to do here is to create a table with all countries that summarize music seconds. The data come from 2 different sources so I want to built a middle table like this...
Two ways you could address this. First would be to transform your tables so you could append them (harder) but the simpler way would be to make a new measure that adds the two values.
NewMeasure = SUM(Table1[Duration]) + SUM(Table2[Duration])
Pat
Two ways you could address this. First would be to transform your tables so you could append them (harder) but the simpler way would be to make a new measure that adds the two values.
NewMeasure = SUM(Table1[Duration]) + SUM(Table2[Duration])
Pat
Hello Pat,
thank you! the 2 sources are too different from each other to merge them. I'd have too many blank columns and loss of info.
I went for the measure idea, that worked perfectly. Thank you so much!