I would like to find the MAX(FYandFW num)
based on each Source.
the sample dataset:
Source FYandFW num sum
Company A 202453 1
Company A 202452 2
Company A 202451 3
Company B 202501 4
Company B 202502 5
Company B 202453 6
What i am trying is below
Amt =
VAR i = VALUES('Table'[Source])
VAR j = VALUES('Table'[FYandFW num])
VAR t =
TOPN(1,
CALCULATETABLE('Table', REMOVEFILTERS(), i),
'Table'[FYandFW num], DESC)
RETURN
CALCULATE(SUM('Table'[sum]),t , j)
Expected Answer is Amt = 5 + 1