0

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.

James Z
  • 12,209
  • 10
  • 24
  • 44

0 Answers0