last order by last date

[Anonymous]

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

id	order number	date	last  order number
1	500	11/31/2016	450
1	450	12/2/2016	450
2	700	10/2/2017	700
2	400	9/30/2017	700

Thanks Advanve, 

[Zubair_Muhammad · Accepted solution]

@Anonymous 

One way could be

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

[Anonymous]

thanks @Zubair_Muhammad   🙂