Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

last order by last date

HI ,

I need Help, i want to create new calculated column  with name last order number to show last order number based on last date if the  id =id  , based on  below  table

idorder number date last  order number
150011/31/2016   450
145012/2/2016450
270010/2/2017700
24009/30/2017700

 

 

Thanks Advanve, 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    One way could be

     

    Column =
MAXX (
    TOPN ( 1, FILTER ( Table1, [id] = EARLIER ( [id] ) ), [date ], DESC ),
    [order number ]
)

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Anonymous 

     

    One way could be

     

    Column =
MAXX (
    TOPN ( 1, FILTER ( Table1, [id] = EARLIER ( [id] ) ), [date ], DESC ),
    [order number ]
)