Forum Discussion

SClarke501's avatar
SClarke501
Frequent Visitor
3 years ago
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...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    SClarke501 ,

     

    Max Target will be

    =

    var _max = maxx(allselected(Table), Table[Date])

    return

    calculate(Max(Table[Cumulative Target]), Filter(allselected(Table) , Table[Date] = _max))

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

If you a certain type, the figures in the cumulative type column are always in ascending order (as sorted by Date), then this measure will work

Measure 1 = calculate(max(Data[cumulative type]),all(Calendar[Date]))  

My assumption is that cumulative type is a column in the Data Table (and not a measure).

Ensure that there is a Calendar Table.  There should be a relationship between the Date column of the Data Table to the Date column of the Calendar Table.  To your visual, drag Date from the Calendar Table.

Hope this helps.