Forum Discussion

SClarke501's avatar
SClarke501
Frequent Visitor
4 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
    4 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))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  SClarke501 ,

Here are the steps you can follow：

1. Create measure.

Measure =
MAXX(ALL('Table'),[Cumulative Target])
Measure 2 =
[Measure] - MAX('Table'[Cumulative Target])

2. Result:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly