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] ) )
)
grazitti_sapna's avatar
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