Forum Discussion

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful 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  ...
Need Help
  • v-jiascu-msft's avatar
    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] ) )

     

     

Omega's avatar
Omega
Icon for Impactful Individual rankImpactful Individual
9 years ago

v-jiascu-msft 

 

Hi Dale,

 

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

 

Please advise. 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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] ) )