Latest Status

[SkorpionAAM]

I'm looking a add custome cloumn for latest status of station with dates ... 

ADDCOLUMNS(

SUMMARIZE('GasStation',[place_digital_adress],"Date",MAX('GasStation'[date])),

"Status",MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress])&&[Date]=EARLIER([Date])),[STATUS_OF_STATION])

)

please anyone help me where Im doing wrong

[amitchandak]

@SkorpionAAM , I think new column show be like this

new column =
var _max = MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress])),[Date])
return
MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress]) && [Date] = _Max)),[STATUS_OF_STATION])

Max of date for place_digital_adress

[SkorpionAAM]

gettting error 

[amitchandak · Accepted solution]

@SkorpionAAM , my bad one additional )

new column =
var _max = MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress])),[Date])
return
MAXX(FILTER('GasStation',[place_digital_adress]=EARLIER([place_digital_adress]) && [Date] = _Max),[STATUS_OF_STATION])