Forum Discussion
MAx value for a column
i have fact table with lots of data...I have claim value ,policy number ,policy expiry date , policy date like columns in the table. i need to take max of claim value where file should be latest fi...
Anonymous , Try measure like
measure =
var _max = maxx(all(Table), Table[upload date])
var _min = eomonth(_max,-12)
return
calculate(maxx(values(Table[policy number]),calculate(sum(Table[Claim Amount]))), filter(Table, Table[policy date] >= _max && Table[policy expiry date] >=_min))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.