Show previous date data and new changes from table 2

[tangutoori]

Dear All,

Am facing the below scenario.

i need to show the O/P as below.

Name	Qty	Date		Hints for solution work around
a	1	06-Jan-23
b	2	06-Jan-23
c	3	06-Jan-23
Name	Qty	Date
a	2	10-Jan-23		Qty changed from 1 to 2
e	3	10-Jan-23		New name added
c	3	10-Jan-23		No qty changed, remove from O/P table
O/P
Name	Qty	Date
a	1	06-Jan-23
b	2	06-Jan-23
c	3	06-Jan-23
a	2	10-Jan-23
e	3	10-Jan-23

[tangutoori]

Hi Amit,

you have mistaken, i need 3rd table as O/P not a column. 

Name	Qty	Date
a	1	06-Jan-23
b	2	06-Jan-23
c	3	06-Jan-23
Name	Qty	Date
a	2	10-Jan-23
e	3	10-Jan-23
c	3	10-Jan-23
O/P
Name	Qty	Date
a	1	06-Jan-23
b	2	06-Jan-23
c	3	06-Jan-23
a	2	10-Jan-23
e	3	10-Jan-23

[amitchandak]

@tangutoori , Try a new column like

New column =
var _date = maxx(filter(Table, Table[Date] < earlier(Table[Date]) ), Table[date])
var _qty = maxx(filter(Table, Table[Date] =_date && [Name] = Earlier([Name]) ), Table[Qty])
return
Switch( true() ,
isblank( _date) , blank(),
isblank(_qty), "New",
[Qty] <> _qty , "Qty Changed From " & _qty & " to " & [Qty],
"Same"
)