Forum Discussion

Yasser92's avatar
Yasser92
Frequent Visitor
8 years ago
Solved

Remove duplicate rows from a calculate table

Hi!    Someone helps me to remove duplicate rows from a calculate Table and take the max value of "Delivery date" for each Order-Line ;    In my case, this is the calculate table  :    Order...
  • dedelman_clng's avatar
    dedelman_clng
    8 years ago
    Unique =
SUMMARIZE (
    Orders,
    Orders[Order],
    Orders[Line],
    "Delivery Date", MAX ( Orders[DelDate] )
)

    Hope this helps,

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
8 years ago
Unique =
SUMMARIZE (
    Orders,
    Orders[Order],
    Orders[Line],
    "Delivery Date", MAX ( Orders[DelDate] )
)

Hope this helps,

David

  • Yasser92's avatar
    Yasser92
    Frequent Visitor
    8 years ago

    Thank you lot dedelman_clng 

    My situation is more complicated then that, cuz my table is not a data but a GENERATE (Table1;Table2).

    I'll try to post the complete case, hoping that someone will help me.

     

     

    • dedelman_clng's avatar
      dedelman_clng
      Community Champion
      8 years ago

      Yasser92 you should be able to do a calculated table (SUMMARIZE retruns a table) against other calculated tables.

      • Yasser92's avatar
        Yasser92
        Frequent Visitor
        8 years ago

        Thank you lot dedelman_clng

        It's Working :D