Forum Discussion

Helper III

3 years ago

Solved

Add max value column

I have this list of quotations, where each quotation has a version, from A and up.

I want to add custom column, that contain the highest version, for each quotation.

Many thanks in advance,

You could try below code:-

Column =
CALCULATE (
    MAX ( 'Table'[version] ),
    FILTER ( 'Table', 'Table'[Quote no] = EARLIER ( 'Table'[Quote no] ) )
)

4 Replies

Samarth_18
Community Champion
3 years ago
Hi RafaelAri ,

You could try below code:-

Column = CALCULATE ( MAX ( 'Table'[version] ), FILTER ( 'Table', 'Table'[Quote no] = EARLIER ( 'Table'[Quote no] ) ) )
- RafaelAri
  Helper III
  3 years ago
  Sorry, doesn't work.
  EARLIER function is not correct.
  Where should I use this code? in Mesures table or in the Query-Editor?
  - RafaelAri
    Helper III
    3 years ago
    My appologies..., it works!
    Thanks Samarth
grazitti_sapna
Super User
3 years ago
Hey Try using this
Create a new column under the modeling tab and try this:
Max Value = Calculate (max('Max Value'[Version]), allexcept('Max Value','Max Value'[Quot. No.]))
Where [Max Value] is the table name