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
Community 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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thx for the quick respons!
That didnt really work but somehow I manage to get it to work with this.

I will look at the video tomorrow.

Get Latest Real_TB1 = 

Var GetDate =
CALCULATE(
    MAX( Fact_KobraRetail[EventDate] ),
    FILTER ( ALL (Fact_KobraRetail ),  Fact_KobraRetail[VehicleNumber] = EARLIER( Fact_KobraRetail[VehicleNumber] ) ) 
)

Var Result =
CALCULATE(
    MAX( Fact_KobraRetail[Real_TB1] ) ,
    FILTER( ALL ( Fact_KobraRetail ),  Fact_KobraRetail[VehicleNumber] = EARLIER( Fact_KobraRetail[VehicleNumber] ) ) ,
        FILTER( ALL ( Fact_KobraRetail ),  GetDate = Fact_KobraRetail[EventDate] ) 
)

RETURN Result

 

//Kman