Forum Discussion
tangutoori
Helper III
Helper IIIShow previous date data and new changes from table 2
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 |
2 Replies
- amitchandak
Super User
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"
) 
tangutooriHi 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
