Forum Discussion

Omega's avatar
Omega
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  ...
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] ) )

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Are you trying to do this in DAX or M or do you care?

 

  • Omega's avatar
    Omega
    Impactful Individual
    9 years ago

    Can you please share both if possible and the difference between both in terms of performance and easiness to implement? Thanks!

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      9 years ago

      Hi, Omega

       

      If you want to use DAX, this formula will help.

      QTYMeasure =

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

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Best Regards

      Dale

      • Omega's avatar
        Omega
        Impactful Individual
        9 years ago

        Thanks for the reply. I'll try to implement and let you know if I'm having challenges. :)