Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

left join two tables both generated from DAX

Hi All, i have a seemingly extremely simple left join to create a combined table in Power BI desktop   I have table 1 which all combinations of 'Month' and 'Customers' (e.g.  all months by all cust...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You could add a column to table 1 like

Transaction amount =
LOOKUPVALUE (
    'Table 2'[Transaction amount],
    'Table 2'[Month], 'Table 1'[Month],
    'Table 2'[Customer], 'Table 1'[Customer]
)