How to SUM values from different tables?

[jhobzvel]

I have 2 sample tables tb1 and tb2.

tb1:

tb2:

My goal is to add the price per month per client country which should look like this but I can't figure out in DAX on how should I do this. I hope you can give some idea on how should I deal with it.

Client	December 2021	January 2022
India	4	7
Philippines	2	5
Singapore	3	6

This is just a sample table to explain what I want to achieve. But in reality, its 2 tables with more different columns where I have many-to-many relationship with Client field

[amitchandak · Accepted solution]

@jhobzvel , Based on what I got, create a common date and country column and join to both tables and analyze with those

https://www.seerinteractive.com/blog/join-many-many-power-bi/

Try to be in star schema

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

[jhobzvel]

It worked like a charm! @amitchandak. Thank you so much!