Forum Discussion

RafaelAri's avatar
RafaelAri
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, ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    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's avatar
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's avatar
RafaelAri
Helper III
3 years ago

My appologies..., it works!
Thanks Samarth