Forum Discussion

Impactful Individual

9 years ago

Solved

Merge tables using latest dates

Dears, I am new to BI and I have a small challenge: I have 3 tables: Sales, QTY and Mapping: Sales: QTY: Mapping: Item| Sales ...

v-jiascu-msft
9 years ago
Omega

Hi,
Maybe you didn’t create relationships among the tables. That could be why the sales is empty. Do the relationships look like this below?
If so, you can use these two measures to get “item2” and “sales”.
Item2Measure =
CALCULATE ( VALUES ( Mapping[item2] ), LASTDATE ( Mapping[date] ) )
QTYMeasure =
CALCULATE ( VALUES ( Qty[qty] ), LASTDATE ( Mapping[date] ) )

Impactful Individual

9 years ago

Hi Dale,

I tried your method but sales are empty. Don't know why :(

Please advise.

Microsoft Employee

9 years ago

Hi,

Maybe you didn’t create relationships among the tables. That could be why the sales is empty. Do the relationships look like this below?

If so, you can use these two measures to get “item2” and “sales”.

Item2Measure =

CALCULATE ( VALUES ( Mapping[item2] ), LASTDATE ( Mapping[date] ) )

QTYMeasure =

CALCULATE ( VALUES ( Qty[qty] ), LASTDATE ( Mapping[date] ) )

Related content