I have below sample data:
IncidentID TransactionID Recordeddate Name Amount
10 1 13/01/2023 Recovery 1000
10 2 13/01/2023 Reserve 2000
10 3 13/01/2023 Reserve 3000
10 4 14/01/2023 Reserve 4000
11 5 14/01/2023 Recovery 3000
11 6 14/01/2023 Payment 4000
12 7 14/01/2023 Reserve 5000
13 8 14/01/2023 Reserve 4000
13 9 14/01/2023 Payment 2000
I need to calculate sum of amount for each incident id, for each date only Max Transaction ID and Name should be Reserve only.
I tried doing it be below expression:
Table2 = summarize(Table,Table[IncidentID],Table[RecordedDate],Table[Name],"MAXID",
calculate(max(TransactionID),AllExcept(IncidentID,RecordDate,Name)))
this table is giving me required filtered table, but i am not able to add amount column. If i add amount column grouping is not working, and i need to get amount included so that i can calculate sum of amount.
Expected- Not able to add amount column in this, as adding amount it is not giving required results.