Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.