Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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,...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

table =
var _tab=
union(
summarize(table1, table1[Report Date], "car",0,"truck",sum(table[Qty])),
summarize(table2, table2[Report Date], "car",sum(table[deilvery]),"truck",0)
)
return
summarize(_tab,[Report Date],"Car",sum([car]),"truck",sum([truck]),"total",sum([car])+sum([truck]))