Add max value column

[RafaelAri]

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,

[grazitti_sapna]

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

[Samarth_18 · Accepted solution]

Hi @RafaelAri ,

You could try below code:-

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

[RafaelAri]

Sorry, doesn't work.

EARLIER function is not correct.

Where should I use this code? in Mesures table or in the Query-Editor?

[RafaelAri]

My appologies..., it works!
Thanks Samarth