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.
Hi
I want to merge tables in different format.
I tried query, naturalleftouterjoin etc but I can not build relationships to work .
When I try to comvert from A to C, duplication occurs. Can you suggest how should I do it to achieve Table E in the end?
Solved! Go to Solution.
Hi @cocomy,
I was abble to replicate your information follow the steps below:
Branch ID
Tokyo | 1 |
Osaka | 2 |
Nagoya | 3 |
Measure created on Daily Forecast Table Daily Forecast Total = VAR Select_Month = MAX ( Calendar[Monthly Date] ) RETURN CALCULATE ( SUM ( 'Daily Forecast'[Daily Forecast] ); 'Daily Forecast'[Monthly Date] = Select_Month ) Measure created on Daily Sales Table Actual totals = SUM('Daily Sales by branch'[Actual])
As you can see the result is what you need to have, I have calculated measure because if you need you can calculate differences and percentages over objective.
Here is a link to PBIX file with the examples and measures.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you very much for detailed explanation. It is what I have been looking for ages.
All the best,
coco
Hi @cocomy,
I was abble to replicate your information follow the steps below:
Branch ID
Tokyo | 1 |
Osaka | 2 |
Nagoya | 3 |
Measure created on Daily Forecast Table Daily Forecast Total = VAR Select_Month = MAX ( Calendar[Monthly Date] ) RETURN CALCULATE ( SUM ( 'Daily Forecast'[Daily Forecast] ); 'Daily Forecast'[Monthly Date] = Select_Month ) Measure created on Daily Sales Table Actual totals = SUM('Daily Sales by branch'[Actual])
As you can see the result is what you need to have, I have calculated measure because if you need you can calculate differences and percentages over objective.
Here is a link to PBIX file with the examples and measures.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you very much for detailed explanation. It is what I have been looking for ages.
All the best,
coco
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |