Forum Discussion

kmansweden2017's avatar
kmansweden2017
Frequent Visitor
3 years ago
Solved

Calculated column with MAX value

Hi,   I am so lost. I dont really know how I would search for a simular problem since i dont know how to explain it without a visual aid. I am trying to get the value from the row with the late...
MAX date
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi kmansweden2017 

    I guess a little bit of CALCULATE won't harm Greg_Deckler  😉

    Latest Real_TB1 =
    MAXX (
    TOPN (
    1,
    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[VehicleNumber] ) ),
    'Table'[EventDate]
    ),
    'Table'[Real_TB1]
    )

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

kmansweden2017 Try:

 

Column = 
  VAR __MaxDate = MAX('Table'[EventDate])
  VAR __MaxDateRealTB1 = MAXX(FILTER(ALL('Table'), [EventDate] = __MaxDate), [Real_TB1])
RETURN
  __MaxDateRealTB1

 

Watch this video if you need more help, especially the last example, Double Lookup.