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.
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
Solved! Go to 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 , 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/
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.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
76 | |
58 | |
47 | |
17 | |
12 |