Forum Discussion
Solved
Set value on last date for all rows
I have a set of data that looks similar to this: Date Type Cumulative Target Delivered 10/04/2021 Pipe 30 30 11/04/2021 Pipe 33 32 12/04/2021 Pipe 42 41 I'm try...
Max Target will be
=
var _max = maxx(allselected(Table), Table[Date])
return
calculate(Max(Table[Cumulative Target]), Filter(allselected(Table) , Table[Date] = _max))
Max Target will be
=
var _max = maxx(allselected(Table), Table[Date])
return
calculate(Max(Table[Cumulative Target]), Filter(allselected(Table) , Table[Date] = _max))