Forum Discussion

Helper V

5 years ago

Solved

Latest Status

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

Data Protection

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

amitchandak
5 years ago
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])

3 Replies

amitchandak
Super User
5 years ago
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
  Helper V
  5 years ago
  gettting error
  - amitchandak
    Super User
    5 years ago
    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])

Related content