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]
    )

tamerj1's avatar
tamerj1
Community Champion
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]
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thx tamerj1, that did produce the same result as my calculation did.

    Now I have two ways to do this 🙂