Forum Discussion
Combine two different tables
Hello, I have a problem I haven't been able to figure out. I have two files that I would like to combine in order to show my data better in my report. The two input files I have are File 1 and 2,...
Hi Anonymous
Sure, you can just create a date dimension join both tables on Report Day
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Later create Two Measures and add them to the table.
Trucks = CALCULATE( SUM( 'Table 4'[Qty] ), 'Table 4'[Filter X] = 460, 'Table 4'[Yes / no] = "Yes", 'Table 4'[Current / Non Current / N/A] = "N/A" )Car = CALCULATE( SUM( 'Table 5'[Qty] ), 'Table 5'[Type 1] = 110, 'Table 5'[Type 2] = "YY" )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Hello both Mariusz & amitchandak , thank you for the fast replies!
I realized my two tables were more "complex" than I showed here. If my lists/tables looks like this instead, how can I merge these two in the best way?
Thank you!
Hi Anonymous
Sure, you can just create a date dimension join both tables on Report Day
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Later create Two Measures and add them to the table.
Trucks =
CALCULATE(
SUM( 'Table 4'[Qty] ),
'Table 4'[Filter X] = 460,
'Table 4'[Yes / no] = "Yes",
'Table 4'[Current / Non Current / N/A] = "N/A"
)Car =
CALCULATE(
SUM( 'Table 5'[Qty] ),
'Table 5'[Type 1] = 110,
'Table 5'[Type 2] = "YY"
)
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.