Forum Discussion
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:
My goal is to build a Filled map that shows seconds from all countries, but so far I could only reach this:
So seconds are not in the same column.
How can I do this?
Thank you!
Best Luca
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
2 Replies
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!
