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

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi Yasser92,

 

What I would add is there's a simpler way in power bi to achieve this. Click Editor Queries-> click on column [Order No], [Line No] and [Delivery Date]-> click Remove Rows-> select Remove duplicates.

Before:

 

After:

 

 

Hope it's helpful to you.

Jimmy Tao

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    8 years ago

    v-yuta-msft -

     

    Yasser92 was asking to remove duplicates for Order-Line and displaying the Max delivery date.  Query Editor would not be able to provide that (note that you have 3 rows for Order AAAB, Line 1)