Summarizing data from two different table

[Vladas]

Hi,

I have two tabels:

'Items' with [ItemId] and 'Sale' with [ItemId] [SalesQty] and [SalesDate].  Relationship is created via [ItemId]

 I would like to create one summarized tabel with columns:   [ItemId] , SUM(SalesQty), LastDate(SalesDate).

How I can do that? 

Thanks

[v-yulgu-msft · Accepted solution]

Hi @Vladas,

New a calculated table with below formula:

Table =
SUMMARIZE (
    Items,
    Items[ItemID],
    "Total SalesQty", SUM ( Sale[SalesQty] ),
    "LatestDate", LASTDATE ( Sale[SalesDate] )
)

Best regards,

Yuliana Gu

[Vladas]

Thanks for help! I had a problem with relationships.