Forum Discussion
jhobzvel
4 years agoFrequent Visitor
How to SUM values from different tables?
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 ...
- 4 years ago
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/
amitchandak
Super User
4 years agojhobzvel , 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
4 years agoFrequent Visitor